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

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:

enter image description here

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

Thanks.

postgresqloracle-sqldeveloperline-numbers


Solution 1:[1]

Preference you set is related to line numbers here:

enter image description 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:

enter image description here

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Littlefoot

Related Questions