Обсуждение: BUG #17060: ERROR: column "rownum" does not exist

The following bug has been logged on the website:

Bug reference:      17060
Logged by:          dhanabakeeswari v
Email address:      dhanabakeeswari15@gmail.com
PostgreSQL version: 11.12
Operating system:   Red Hat Enterprise Linux Server (7.8 version)
Description:

Migrated the data from the oracle database to the PostgreSQL database.
While accessing the query I am facing "org.postgresql.util.PSQLException:
ERROR: column "rownum" does not exist".
Without query changes how to resolve this.

On Wed, 16 Jun 2021 at 22:41, PG Bug reporting form
<noreply@postgresql.org> wrote:
> Migrated the data from the oracle database to the PostgreSQL database.
> While accessing the query I am facing "org.postgresql.util.PSQLException:
> ERROR: column "rownum" does not exist".
> Without query changes how to resolve this.

It looks like you might have to do a bit more work to properly migrate
your application to PostgreSQL.

PostgreSQL uses more standardized ways to limit the number of records
returned by a query. The last time I used Oracle it did not follow the
SQL standard way of doing that.

With PostgreSQL, you should use either the standard FETCH FIRST syntax
or the LIMIT syntax, which predates the SQL standard.
https://www.postgresql.org/docs/11/sql-select.html#SQL-LIMIT

Since this is not a bug, please divert any follow-up questions to the
pgsql-general mailing list.

David