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 3CA799DCC26; Tue, 6 Dec 2005 13:12:49 -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 46348-02; Tue, 6 Dec 2005 13:12:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C29EA9DCAB0; Tue, 6 Dec 2005 13:12:46 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jB6HCkUA004844; Tue, 6 Dec 2005 12:12:46 -0500 (EST) To: Emil Rachovsky cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] lost in system tables In-reply-to: <20051206154755.86057.qmail@web54314.mail.yahoo.com> References: <20051206154755.86057.qmail@web54314.mail.yahoo.com> Comments: In-reply-to Emil Rachovsky message dated "Tue, 06 Dec 2005 07:47:55 -0800" Date: Tue, 06 Dec 2005 12:12:46 -0500 Message-ID: <4843.1133889166@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.002 required=5 tests=[AWL=0.002] X-Spam-Score: 0.002 X-Spam-Level: X-Archive-Number: 200512/326 X-Sequence-Number: 87889 Emil Rachovsky writes: > I am trying to find the equivalent of these two > Sybase system columns : > check_on_commit (Y/N) - Indicates whether INSERT and > UPDATE commands should wait until the next COMMIT > command to check if foreign keys are valid. I think you are looking for the DEFERRABLE/DEFERRED option of foreign key constraints. > nulls (Y/N) - Indicates whether the columns in the > foreign key are allowed to contain the NULL value. > Note that this setting is independent of the nulls > setting in the columns contained in the foreign key. No such animal in the SQL standard --- though perhaps MATCH FULL is approximately what you are looking for? Your description as stated makes no sense at all; either the columns are allowed to be null, or they're not. regards, tom lane