Re: BUG #17060: ERROR: column "rownum" does not exist
| От | Pantelis Theodosiou |
|---|---|
| Тема | Re: BUG #17060: ERROR: column "rownum" does not exist |
| Дата | |
| Msg-id | CAE3TBxymboVF+YkO9Ctg6rWcsj6m-PATuqq3=UQR29OxGmu6+g@mail.gmail.com обсуждение исходный текст |
| Ответ на | BUG #17060: ERROR: column "rownum" does not exist (PG Bug reporting form <noreply@postgresql.org>) |
| Ответы |
Re: BUG #17060: ERROR: column "rownum" does not exist
|
| Список | pgsql-bugs |
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 по дате отправления: