Updateing pg_trigger and pg_constraint

From: Craig Servin <cservin(at)cdhps(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Updateing pg_trigger and pg_constraint
Date: 2005-08-16 20:18:26
Message-ID: 200508161518.26834.cservin@cdhps.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2005-08-16 21:05:33 Re: how to do a select * and decrypt a column at the same time?
Previous Message The One 2005-08-16 19:53:51 how to do a select * and decrypt a column at the same time?