于2012年9月17日 9:48:58,Tom Lane写到:
Rural Hunter <[email protected]> writes:# select oid, * from pg_class WHERE reltoastrelid = 16439148; oid | relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relfrozenxid | relacl | reloptions ----------+--------------+--------------+----------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+--------------+-----------------------------------------+------------ 16439145 | sql_features | 16438995 | 16439147 | 0 | 10 | 0 | 16439145 | 0 | 0 | 0 | 16439148 | 0 | f | f | p | r | 7 | 0 | f | f | f | f | f | 630449585 | {postgres=arwdDxt/postgres,=r/postgres} | (1 row)Well, that's even stranger, because (1) information_schema.sql_features ought to have a toast table in either version, and (2) neither pg_dump nor pg_upgrade ought to be attempting to dump or transfer that table. I wonder whether you dropped and recreated the information_schema in the lifetime of this database? We have recommended doing that in the past, IIRC. Could such a thing have confused pg_dump? regards, tom lane
No, I have never manually re-created the table. This is the first time I see the name. But I'm not sure other things I installed before recreated it or not, such as pg_buffercache etc. One more thing, is this a hidden table? I can see it with '\d information_schema.sql_features' but it's not in the list of '\d'.
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
