Re: Check constraints on non-immutable keys - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Check constraints on non-immutable keys
Date
Msg-id AANLkTimVvF2MboiGKc0n5KMpCLfA8yIocfqKl4_gfUBu@mail.gmail.com
Whole thread Raw
In response to Re: Check constraints on non-immutable keys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Jun 30, 2010 at 20:13, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Magnus Hagander <magnus@hagander.net> writes:
>> On Wed, Jun 30, 2010 at 19:16, Tom Lane <tgl@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 HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: [BUGS] Server crash while trying to read expression using pg_get_expr()
Next
From: Simon Riggs
Date:
Subject: Re: Admission Control