All, Just encountered this:
create table josh ( id serial not null, desc text ); pg_dump -Fc -T josh -f no_josh_dump postgres pg_dump -Fc -t josh -f josh_dump postgres pg_restore -d new no_josh_dump pg_restore -d new josh_dump pg_restore: [archiver (db)] Error from TOC entry 2645; 1259 49910 SEQUENCE josh_id_seq postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "josh_id_seq" already exists It seems that if I exclude a table using -T, its dependant sequences do not get excluded. But if I include it using -t, its dependent sequences *do* get included. Is there a reason this is a good idea, or is it just an oversight? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers