X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A60A49DCB51 for ; Wed, 7 Dec 2005 03:39:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57855-02 for ; Wed, 7 Dec 2005 03:39:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web54311.mail.yahoo.com (web54311.mail.yahoo.com [206.190.49.121]) by postgresql.org (Postfix) with SMTP id 367FE9DCB55 for ; Wed, 7 Dec 2005 03:39:25 -0400 (AST) Received: (qmail 4085 invoked by uid 60001); 7 Dec 2005 07:39:23 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=zmbWDFgyNJ8k6v07iT/BDDrpvtd+Kf3Q0/ovFcvjEEM/EMcUmbKrhPBO3ufwWhCWSMp6giVnxSGCR5ESr5mXkze4RMLVGDFpgeFkwhJxy2d0AMRy3NTZ97Xt5rAO3d7Y4BP3lVuR01W/n/tpW3GtgShKf1C4VCDZP282DKiOCSU= ; Message-ID: <20051207073923.4083.qmail@web54311.mail.yahoo.com> Received: from [213.91.244.26] by web54311.mail.yahoo.com via HTTP; Tue, 06 Dec 2005 23:39:23 PST Date: Tue, 6 Dec 2005 23:39:23 -0800 (PST) From: Emil Rachovsky Subject: Re: [SQL] lost in system tables To: luca@cs.ualberta.ca Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: <200512060934.59140.luca@cs.ualberta.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.373 required=5 tests=[AWL=-0.106, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.373 X-Spam-Level: X-Archive-Number: 200512/350 X-Sequence-Number: 87913 > Those parameters are specified when you declare the > foreign key. Look here, > in the section describing "references": > http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html > > Luca Thank you,Luca I know that these parameters are specified when you declare the foreign key, but i need to check them out later from the system tables. The first one must be something like the 'deferrable' column in pg_constaint, but the second is still in vague. Emil __________________________________________ Yahoo! DSL – Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com