"Igor Neyman" <ineyman@xxxxxxxxxxxxxx> writes: > Attached is script that could be used to pre-create "parent" tables > (from which partitions were inherited). Thanks. Now that I dig into it, it looks like the actual trigger for the problem is that pg_dump, not pg_restore, couldn't seek while it was creating the dump file --- so it didn't seek back and update the file's table-of-contents with exact dump offsets. What command did you use to create the dump file, exactly? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
