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?
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
В списке pgsql-bugs по дате отправления: