X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id DF56CEFF3C for ; Thu, 5 Jun 2003 14:55:43 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 11283-05 for ; Thu, 5 Jun 2003 14:55:42 +0000 (GMT) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by svr1.postgresql.org (Postfix) with SMTP id 35545EFF7F for ; Thu, 5 Jun 2003 14:55:39 +0000 (GMT) Received: (qmail 20613 invoked from network); 5 Jun 2003 15:00:18 -0000 Received: from unknown (HELO trade-india.com) (unknown) by unknown with SMTP; 5 Jun 2003 15:00:18 -0000 Received: (qmail 8487 invoked by uid 505); 5 Jun 2003 14:55:33 -0000 Received: from mallah@trade-india.com by ns1.trade-india.com by uid 502 with qmail-scanner-1.16 (clamscan: 0.54. spamassassin: 2.54. Clear:SA:0(-98.1/5.0):. Processed in 0.563952 secs); 05 Jun 2003 14:55:33 -0000 Received: from ns1.trade-india.com (HELO trade-india.com) (66.234.10.14) by ns1.trade-india.com with SMTP; 5 Jun 2003 14:55:32 -0000 Received: from 219.65.253.151 (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Thu, 5 Jun 2003 20:25:32 +0530 (IST) Message-ID: <1153.219.65.253.151.1054824932.squirrel@mail.trade-india.com> Date: Thu, 5 Jun 2003 20:25:32 +0530 (IST) Subject: simulating partial fkeys.. From: To: X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=MISSING_MIMEOLE, MISSING_OUTLOOK_NAME, NO_REAL_NAME X-Spam-Level: ** X-Archive-Number: 200306/29 X-Sequence-Number: 13787 hi , Is there any way to enforce fkeys only on subset of the table something on the lines of unique partial indexes or any work around ? (on update or insert trigger is the only thing i can think of) regds mallah. ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/