Postgres Pro
Downloads
Home   >   mailing lists

Thread: problem with pg_dump - attrdef record(s) missing

problem with pg_dump - attrdef record(s) missing

From
richard
Date:
Hi all,

I run a script every week to dump a database to file . This
message looks interesting:

pg_dump: WARNING:  2 attrdef record(s) missing for rel pumanew
pg_dump: invalid column numbering in table "pumanew"

I thought I should ask here before I begin investigating.

Any Ideas?

I am running ver 8.1

Richard A Lough

Re: problem with pg_dump - attrdef record(s) missing

From
Tom Lane
Date:
richard <richard@sheugh.com> writes:
> I run a script every week to dump a database to file . This
> message looks interesting:
> pg_dump: WARNING:  2 attrdef record(s) missing for rel pumanew
> pg_dump: invalid column numbering in table "pumanew"

> I am running ver 8.1

If you were defining a bunch of tables concurrently in different
sessions at the time this table was created, you might have gotten
bit by the bug described here:
http://archives.postgresql.org/pgsql-hackers/2006-01/msg00206.php
It's fixed in 8.1.2.

            regards, tom lane