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 C245C52800 for ; Wed, 3 Aug 2005 13:26:38 -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 03284-10 for ; Wed, 3 Aug 2005 16:26:30 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by svr1.postgresql.org (Postfix) with ESMTP id B8D6F52991 for ; Wed, 3 Aug 2005 13:26:28 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so96628nzo for ; Wed, 03 Aug 2005 09:26:29 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dC7kPBZ85+VFKGk6S+ck2KPcrZ//bX+Mh24b14Sxsg9M2NDaVyzUqXMSPK1olWpgYYnLJ+uynmE2Y2Bhsxk2GE3NOtR6RYOYp8HGUWCj47q6wLRa21U2BZgMwWoFJ4AviRwEqXQ66bXJITMhBfYCxg834aH7lhDY0Y7mIdN54n4= Received: by 10.37.20.72 with SMTP id x72mr208073nzi; Wed, 03 Aug 2005 09:26:29 -0700 (PDT) Received: by 10.36.25.14 with HTTP; Wed, 3 Aug 2005 09:26:29 -0700 (PDT) Message-ID: <1d219a6f0508030926630c211f@mail.gmail.com> Date: Wed, 3 Aug 2005 12:26:29 -0400 From: Chris Hoover To: Tom Lane Subject: Re: Help converting constraint triggers Cc: pgsql-admin@postgresql.org In-Reply-To: <1822.1123084401@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1d219a6f05080308271131c8d9@mail.gmail.com> <1822.1123084401@sss.pgh.pa.us> 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/38 X-Sequence-Number: 18357 I tried running this an a test db, and it got some, but not all of the constraint triggers. Is there anything else to try? Also, was my interpretation of the constraint trigger correct? While there are many constraint triggers defined, I don't think the volume is large enough to make it prohibitive for me to just convert them by hand. Thanks, Chris On 8/3/05, Tom Lane wrote: > Chris Hoover writes: > > I need some help understanding how to convert constraint triggers to > > normal foreign keys. >=20 > You might try the contrib/adddepend script ... >=20 > regards, tom lane >