Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4

On Thu, May 9, 2013 at 04:21:05PM -0400, Evan D. Hoffman wrote:
> Looks like your guess was correct:
>
> [ehoffman(at)dev-db2 ~]$ psql -Upostgres db -p 5433
> psql (9.2.4)
> Type "help" for help.
>
> db=# SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class
> db-# WHERE reltoastrelid = 299749;
> oid | relname | reltoastrelid | reltoastidxid
> -------+-----------+---------------+---------------
> 17304 | setupinfo | 299749 | 0
> (1 row)
>
> db=# \q
> [ehoffman(at)dev-db2 ~]$ psql -Upostgres db -p 5432
> psql (9.2.4, server 9.1.9)
> WARNING: psql version 9.2, server version 9.1.
> Some psql features might not work.
> Type "help" for help.
>
> db=# SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class
> db-# WHERE oid = 17304;
> oid | relname | reltoastrelid | reltoastidxid
> -------+-----------+---------------+---------------
> 17304 | setupinfo | 0 | 0
> (1 row)

OK, that's progress. Having received the table schema privately via
email, I see several 'character varying(40)' fields in the schema. So
the question is how was this table able to get away without a TOAST
table in 9.1, while 9.2 created one for an empty table? Ideas?

Evan, is there anything unusual about this table or its history?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

--
Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers