Обсуждение: 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
On Wed, Jun 16, 2021 at 11:41 AM PG Bug reporting form <noreply@postgresql.org> wrote:
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.
This is (much likely) not a bug. ROWNUM is a pseudo column that is specific in Oracle SQL. You can't solve this without modifying your query (eg using ROW_NUMBER() window function).
Best regards
Pantelis Theodosiou
Hi
im facing com.edb.util.PSQLException: Cannot commit when autoCommit is enabled.
could you please help me to solve this?
im facing com.edb.util.PSQLException: Cannot commit when autoCommit is enabled.
could you please help me to solve this?
On Wed, Jun 16, 2021 at 4:18 PM Pantelis Theodosiou <ypercube@gmail.com> wrote:
On Wed, Jun 16, 2021 at 11:41 AM PG Bug reporting form <noreply@postgresql.org> wrote: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.This is (much likely) not a bug. ROWNUM is a pseudo column that is specific in Oracle SQL. You can't solve this without modifying your query (eg using ROW_NUMBER() window function).Best regardsPantelis Theodosiou