| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | dhanabakeeswari15(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #17060: ERROR: column "rownum" does not exist |
| Date: | 2021-06-16 10:47:10 |
| Message-ID: | CAApHDvpj2k2odcw6XTeMVzjQRGnG2_dtjcisMXS9meBiTJ8Zrg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, 16 Jun 2021 at 22:41, PG Bug reporting form
<noreply(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pantelis Theodosiou | 2021-06-16 10:47:53 | Re: BUG #17060: ERROR: column "rownum" does not exist |
| Previous Message | PG Bug reporting form | 2021-06-16 09:42:19 | BUG #17060: ERROR: column "rownum" does not exist |