Re: Changing constraints to deferrable

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Changing constraints to deferrable
Date: 2005-03-24 15:45:55
Message-ID: 7064f73ccc5ca4a15a0ee2ba7a7b9651@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 24, 2005, at 12:42 AM, Greg Stark wrote:

> There could be some tricky bits around making a deferrable constraint
> not
> deferrable. And disabling a constraint would be nice too, reenabling
> it would
> require rechecking but at least it would eliminate the error-prone
> manual
> process of reentering the definition.
>

there are some tricky bits. check the archives for either this list or
the performance list for what I did to mark my reference checks
deferrable. it was within the last few months (no more than 6).

Vivek Khera, Ph.D.
+1-301-869-4449 x806

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ricardo Fonseca e Campos 2005-03-24 15:53:55 How to get the size in bytes of a table data
Previous Message Jeff Amiel 2005-03-24 15:28:30 Converting from single user w/pool to multiple users