Re: BUG #17060: ERROR: column "rownum" does not exist

Поиск
Список
Период
Сортировка
От dhanabakeeswari v
Тема Re: BUG #17060: ERROR: column "rownum" does not exist
Дата
Msg-id CAJfs5vb78u2jjCizObNYb=0uASH_PQecOzT0Oy3jSDxaf+DzPQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17060: ERROR: column "rownum" does not exist  (Pantelis Theodosiou <ypercube@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
Hi
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 regards

Pantelis Theodosiou

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #17064: Parallel VACUUM operations cause the error "global/pg_filenode.map contains incorrect checksum"
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: IRe: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows