pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17060: ERROR: column "rownum" does not exist
4+ messages / 4 participants
[nested] [flat]
* BUG #17060: ERROR: column "rownum" does not exist
@ 2021-06-16 09:42 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 2 replies; 4+ messages in thread
From: PG Bug reporting form @ 2021-06-16 09:42 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: dhanabakeeswari15@gmail.com
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #17060: ERROR: column "rownum" does not exist
@ 2021-06-16 10:47 David Rowley <dgrowleyml@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 0 replies; 4+ messages in thread
From: David Rowley @ 2021-06-16 10:47 UTC (permalink / raw)
To: dhanabakeeswari15@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Wed, 16 Jun 2021 at 22:41, PG Bug reporting form
<noreply@postgresql.org> wrote:
> 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.
It looks like you might have to do a bit more work to properly migrate
your application to PostgreSQL.
PostgreSQL uses more standardized ways to limit the number of records
returned by a query. The last time I used Oracle it did not follow the
SQL standard way of doing that.
With PostgreSQL, you should use either the standard FETCH FIRST syntax
or the LIMIT syntax, which predates the SQL standard.
https://www.postgresql.org/docs/11/sql-select.html#SQL-LIMIT
Since this is not a bug, please divert any follow-up questions to the
pgsql-general mailing list.
David
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #17060: ERROR: column "rownum" does not exist
@ 2021-06-16 10:47 Pantelis Theodosiou <ypercube@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 1 reply; 4+ messages in thread
From: Pantelis Theodosiou @ 2021-06-16 10:47 UTC (permalink / raw)
To: dhanabakeeswari15@gmail.com; pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #17060: ERROR: column "rownum" does not exist
@ 2021-06-24 11:17 dhanabakeeswari v <dhanabakeeswari15@gmail.com>
parent: Pantelis Theodosiou <ypercube@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: dhanabakeeswari v @ 2021-06-24 11:17 UTC (permalink / raw)
To: Pantelis Theodosiou <ypercube@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-06-24 11:17 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-16 09:42 BUG #17060: ERROR: column "rownum" does not exist PG Bug reporting form <noreply@postgresql.org>
2021-06-16 10:47 ` David Rowley <dgrowleyml@gmail.com>
2021-06-16 10:47 ` Pantelis Theodosiou <ypercube@gmail.com>
2021-06-24 11:17 ` dhanabakeeswari v <dhanabakeeswari15@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox