From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Arne Henrik Segtnan <arne(at)basis-consulting(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" |
Date: | 2021-05-04 16:43:36 |
Message-ID: | 3911279.1620146616@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Arne Henrik Segtnan <arne(at)basis-consulting(dot)com> writes:
> When trying to upgrade from PostgreSQL 10 to 12, the installation fails as shown below.
> 2021-05-04 13:06:05.614 CEST [12890] postgres(at)zabbix_db ERROR: column r.relhasoids does not exist at character 1616
> 2021-05-04 13:06:05.614 CEST [12890] postgres(at)zabbix_db STATEMENT:
> -- For binary upgrade, must preserve pg_type oid
> SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('162222'::pg_catalog.oid);
> -- For binary upgrade, must preserve pg_type array oid
> SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('162221'::pg_catalog.oid);
> -- For binary upgrade, must preserve pg_class oids
> SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('162220'::pg_catalog.oid);
> CREATE VIEW "repack"."tables" AS
> SELECT ("r"."oid")::"regclass" AS "relname",
> "r"."oid" AS "relid",
> "r"."reltoastrelid",
> CASE
> .
> .
> .
You didn't show us the rest of the command, but it looks like
this view contains a reference to pg_class.relhasoids. As
Bruce noted, that column no longer exists, so you're not going
to be able to transparently upgrade this view.
I don't know what this view is from, though the schema name
"repack" is suggestive. Possibly you could drop whatever it's
a part of, and then reinstall an updated version after upgrading?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-05-04 16:46:58 | Re: AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 |
Previous Message | Magnus Hagander | 2021-05-04 16:40:02 | Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" |