| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Venkata B Nagothi <nag1010(at)gmail(dot)com> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgres upgrade 12 - issues with OIDs |
| Date: | 2021-05-16 01:00:42 |
| Message-ID: | CAKFQuwYj_x7S9Tb_9B69cMokgM7xWohxc9ysRysb86va53iTpw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Saturday, May 15, 2021, Venkata B Nagothi <nag1010(at)gmail(dot)com> wrote:
>
>
> *ERROR: column c.relhaspkey does not exist at character 33*
>
> Below is the query generating the error :
>
> STATEMENT: SELECT c.relname AS table_name, c.relhaspkey AS
> has_primary_key FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE
> c.relkind = 'r' AND c.relnamespace = n.oid AND n.nspname = $1
>
> Any advice on how bad it is and how to get rid of it would be great.
>
Figure out what is issuing the query and either fix it or upgrade to a
version that has been fixed.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2021-05-16 12:45:02 | Re: Empty tablespace directory after restore with psql -d dbname -f dump.sql |
| Previous Message | Venkata B Nagothi | 2021-05-16 00:53:55 | Re: Postgres upgrade 12 - issues with OIDs |