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 95AC452806 for ; Wed, 3 Aug 2005 12:27:35 -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 89338-10 for ; Wed, 3 Aug 2005 15:27:32 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by svr1.postgresql.org (Postfix) with ESMTP id 48C3752809 for ; Wed, 3 Aug 2005 12:27:31 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so89990nzo for ; Wed, 03 Aug 2005 08:27:30 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=WG2j8NzmB1pCrESjt0dRsci7JzLQ0YTO1m2HloG7oDKzB0bDBGXj6WaNc0UsaPA+kWI8DG1ujE9Eo01rVOMDjCDVyxzhJNOqGHDI2+z0nqy/a9Bj9IQ3I2P/wu4dW5U9/M6kHXzdwTM5AkqRsyxeqteyzeElVvdhxs4XHvXAjhM= Received: by 10.36.178.17 with SMTP id a17mr315476nzf; Wed, 03 Aug 2005 08:27:30 -0700 (PDT) Received: by 10.36.25.14 with HTTP; Wed, 3 Aug 2005 08:27:30 -0700 (PDT) Message-ID: <1d219a6f05080308271131c8d9@mail.gmail.com> Date: Wed, 3 Aug 2005 11:27:30 -0400 From: Chris Hoover To: pgsql-admin@postgresql.org Subject: Help converting constraint triggers Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/35 X-Sequence-Number: 18354 I need some help understanding how to convert constraint triggers to normal foreign keys. I have several of them in my database that a previous dba created. Since they don't show up in most PostgreSQL tools, they are becoming a real pain to deal with. Here is an example of on of the constraint triggers: CREATE CONSTRAINT TRIGGER sys_user_group_id_fkey AFTER INSERT OR UPDATE ON sys_user FROM sys_group NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('sys_user_group_id_fkey', 'sys_user', 'sys_group', 'UNSPECIFIED', 'group_id', 'group_id'); I believe this is the same as the foriegn key definition, alter table sys_user=20 add constraint sys_user_group_id_fkey foreign key(group_id) references sys_group(group_id) not deferrrable; Is this correct? If not, how would be proper foreign key be defined? Thanks, Chris