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 по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: BUG #17060: ERROR: column "rownum" does not exist
Следующее
От: Pawel Kudzia
Дата:
Сообщение: Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows