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

On Thu, May  9, 2013 at 04:21:05PM -0400, Evan D. Hoffman wrote:
> Looks like your guess was correct:
> 
> [ehoffman@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@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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +