| From: | Pantelis Theodosiou <ypercube(at)gmail(dot)com> |
|---|---|
| To: | dhanabakeeswari15(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #17060: ERROR: column "rownum" does not exist |
| Date: | 2021-06-16 10:47:53 |
| Message-ID: | CAE3TBxymboVF+YkO9Ctg6rWcsj6m-PATuqq3=UQR29OxGmu6+g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pawel Kudzia | 2021-06-17 06:40:18 | Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows |
| Previous Message | David Rowley | 2021-06-16 10:47:10 | Re: BUG #17060: ERROR: column "rownum" does not exist |