X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D705452C19 for ; Wed, 17 Aug 2005 15:00:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74750-04 for ; Wed, 17 Aug 2005 18:00:34 +0000 (GMT) Received: from bedrock.cromagnon.com (170-215-19-8.dsl1.mnd.mn.frontiernet.net [170.215.19.8]) by svr1.postgresql.org (Postfix) with ESMTP id 6BAD752C05 for ; Wed, 17 Aug 2005 15:00:32 -0300 (ADT) Received: from lt-cservin.cdhps.com (cservin.dsl.visi.com [209.98.143.247]) (authenticated bits=0) by bedrock.cromagnon.com (8.12.8/8.12.8) with ESMTP id j7HI0VrF028171 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO) for ; Wed, 17 Aug 2005 13:00:33 -0500 Resent-From: Craig Servin Resent-To: pgsql-admin@postgresql.org Resent-Date: Wed, 17 Aug 2005 13:00:04 -0500 Resent-Message-ID: <200508171300.04147.cservin@cromagnon.com> Resent-From: Craig Servin Resent-To: pgsql-admin@postgresql.org Resent-Date: Wed, 17 Aug 2005 12:51:16 -0500 Resent-Message-ID: <200508171251.16347.cservin@cromagnon.com> From: Craig Servin Organization: Cro-Magnon To: pgsql-admin@postgresql.org Subject: Updateing pg_trigger and pg_constraint Date: Wed, 17 Aug 2005 13:00:33 -0500 User-Agent: KMail/1.8.1 MIME-Version: 1.0 Content-Disposition: inline Message-Id: <200508161521.23802.cservin@cromagnon.com> X-Length: 1220 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[AWL=-0.000, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/229 X-Sequence-Number: 18548 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