From: Craig Servin <cservin@cdhps.com>
Organization: CMS
To: pgsql-sql@postgresql.org
Subject: Updateing pg_trigger and pg_constraint
Date: Tue, 16 Aug 2005 15:18:26 -0500
User-Agent: KMail/1.8.1
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200508161518.26834.cservin@cdhps.com>

I am trying to make some foreign keys deferrable and initially deferred.  
These foreign key constraints already exist so I was going to change them by 
updating pg_trigger and pg_constraint.

However the changes do not seem to take affect.  Is there something I need to 
do to get PostgreSQL to recognize that I have tweaked it's tables?

This is the query that I used:

begin work;
update pg_constraint set condeferrable = true, condeferred = true where 
contype ='f';
update pg_trigger set tgdeferrable = true, tginitdeferred = true where 
tgconstrname in ( select conname from pg_constraint where contype = 'f' );
commit

any help would be appreciated,

Craig