Re: Check constraints on non-immutable keys

On Wed, Jun 30, 2010 at 20:13, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
>> On Wed, Jun 30, 2010 at 19:16, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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/