Line Numbers for Errors not returning in SQL Developer when querying postgres

Question

As the title states, I am not getting the line numbers for errors in SQL Developer when I query a Postgres DB. Just a position error. Something like:

ERROR: syntax error at or near "SELECT"
Position: 135

I went into the preference and have the 'Show Line Numbers' enabled:

but they aren't showing. Is this an issue with Postgres in SQL Developer or something else?

Thanks.

Looks like an issue with your editor, I tried 2 different editors on some bad SQL and both gave me a nice error message. Including the line and position of the error. — Frank Heikens
– Frank Heikens, Commented Jan 26, 2022 at 19:26

Littlefoot · Accepted Answer · 2022-01-26 21:34:01Z

0

Preference you set is related to line numbers here:

(that's the result of a mouse right-click).

What you're looking for is related to the way database reports errors. As far as Oracle is concerned, it works as expected:

As I don't use PostgreSQL, I can't comment it.

answered Jan 26, 2022 at 21:34

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mike Over a year ago

Thanks @Littlefoot I think you might be on to something. This is likely an issue with the database returning the error as opposed ot SQL Developer. I'll have a look at that and see if there's something that can be done in Postgres.

Littlefoot Over a year ago

You're welcome; good luck!

Collectives™ on Stack Overflow

Line Numbers for Errors not returning in SQL Developer when querying postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related