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. +