Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17060: ERROR: column "rownum" does not exist - Mailing list pgsql-bugs

From Pantelis Theodosiou
Subject Re: BUG #17060: ERROR: column "rownum" does not exist
Date
Msg-id CAE3TBxymboVF+YkO9Ctg6rWcsj6m-PATuqq3=UQR29OxGmu6+g@mail.gmail.com
Whole thread Raw
In response to BUG #17060: ERROR: column "rownum" does not exist  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17060: ERROR: column "rownum" does not exist  (dhanabakeeswari v <dhanabakeeswari15@gmail.com>)
List pgsql-bugs
Tree view


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

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #17060: ERROR: column "rownum" does not exist
Next
From: Pawel Kudzia
Date:
Subject: Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows