Re: Changing constraints to deferrable

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, pgsql-general(at)postgresql(dot)org
Subject: Re: Changing constraints to deferrable
Date: 2005-03-22 23:33:54
Message-ID: 87d5tr9rx9.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Greg Stark <gsstark(at)mit(dot)edu> writes:
> > Is it enough to just do
> > update pg_constraint set condeferrable = 't' where contype = 'f';
>
> I think you'd need to start a fresh backend session --- the relcache
> entries for the tables probably won't notice the above hack.

Sorry, forgot to mention that I did that.

--
greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-03-23 01:01:22 Re: OSX, ODBC and Office 2004
Previous Message Thomas F.O'Connell 2005-03-22 23:15:28 checkpoint_timeout