On Wed, Jun 30, 2010 at 20:13, Tom Lane <t...@sss.pgh.pa.us> wrote: > Magnus Hagander <mag...@hagander.net> writes: >> On Wed, Jun 30, 2010 at 19:16, Tom Lane <t...@sss.pgh.pa.us> wrote: >>> I concur with the thought that the most useful solution might be a way >>> to tell pg_restore to remove or disable check constraints. > >> Uh, say what? Are you saying pg_restore should actually remove >> something from the database schema? And thus no longer be valid for >> taking database backups? > > pg_restore, not pg_dump. It's no more unreasonable an idea than the > current pg_restore options for selective restores, AFAICS. You can > already cause pg_restore to not restore PK and FK constraints, for > example, so why not check constraints?
Oh, sorry, I misread that - I thought you suggested it would do so by default. Clearly, I should've left work about 2 minutes earlier and not bothered you with that response :-) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers