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

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(at)gmail(dot)com>
wrote:

>
>
> On Wed, Jun 16, 2021 at 11:41 AM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 17060
>> Logged by: dhanabakeeswari v
>> Email address: dhanabakeeswari15(at)gmail(dot)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
>