Re: Changing constraints to deferrable - Mailing list pgsql-general

From Vivek Khera
Subject Re: Changing constraints to deferrable
Date
Msg-id 7064f73ccc5ca4a15a0ee2ba7a7b9651@khera.org
Whole thread Raw
In response to Re: Changing constraints to deferrable  (Greg Stark <gsstark@mit.edu>)
List 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


pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Converting from single user w/pool to multiple users
Next
From: "Ricardo Fonseca e Campos"
Date:
Subject: How to get the size in bytes of a table data