Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id AF38E475AB5 for ; Tue, 28 May 2002 17:18:03 -0400 (EDT) Received: from kennedy.calorieking.com (adsl-64-164-82-57.dsl.lsan03.pacbell.net [64.164.82.57]) by postgresql.org (Postfix) with ESMTP id 84DFF475CFB for ; Tue, 28 May 2002 17:12:37 -0400 (EDT) Received: (from root@localhost) by kennedy.calorieking.com (8.11.6/8.11.6) id g4SLCc526626 for pgsql-sql@postgresql.org; Tue, 28 May 2002 14:12:38 -0700 (PDT) (envelope-from chriskl@familyhealth.com.au) Received: from fhpusa1 (work-50.internal [192.168.0.50]) by kennedy.calorieking.com (8.11.6/8.9.3) with SMTP id g4SLCar26561; Tue, 28 May 2002 14:12:37 -0700 (PDT) Message-ID: <03e801c2068c$5fb41260$3200a8c0@internal> From: "Christopher Kings-Lynne" To: "Beth Gatewood" , References: <004a01c20678$0ee472d0$6901a8c0@bethvizx> Subject: Re: query system tables to find columns unique constraint is constraining? Date: Tue, 28 May 2002 14:12:28 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/) X-Archive-Number: 200205/302 X-Sequence-Number: 7937 It's all in the pg_index table. Check for unique indices. Chris ----- Original Message ----- From: "Beth Gatewood" To: Sent: Tuesday, May 28, 2002 11:47 AM Subject: [SQL] query system tables to find columns unique constraint is constraining? > > > Hi- > > I have been fiddling around trying to figure out which columns some unique > constraints are constraining by querying the system tables.....with zero > luck. > > Can anyone suggest how to do this? > > thank! > Beth > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >