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
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? |