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 1E3E99DCBBC for ; Tue, 6 Dec 2005 11:47:55 -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 32982-03 for ; Tue, 6 Dec 2005 11:47:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web54314.mail.yahoo.com (web54314.mail.yahoo.com [206.190.49.124]) by postgresql.org (Postfix) with SMTP id AA4F69DCB8E for ; Tue, 6 Dec 2005 11:47:51 -0400 (AST) Received: (qmail 86059 invoked by uid 60001); 6 Dec 2005 15:47:55 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=B0VTAcAwTGZxBxuYOE8FemSqoHrsYTX3bYHU3Zerju7zPg8iUF3BnP3adRGAAkr/VJTJlqPVW61SUFHW9XeUvJeN2AYP2MmkHBRcvc12sxWAK3byj9wlfwCZ6iTE0Cw60YWamdXBE//kwUAV7weUImaMl3JbwQfTwCbHSLHDFrc= ; Message-ID: <20051206154755.86057.qmail@web54314.mail.yahoo.com> Received: from [213.91.244.26] by web54314.mail.yahoo.com via HTTP; Tue, 06 Dec 2005 07:47:55 PST Date: Tue, 6 Dec 2005 07:47:55 -0800 (PST) From: Emil Rachovsky Subject: lost in system tables To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org 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.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200512/322 X-Sequence-Number: 87885 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. A foreign key is valid if, for each row in the foreign table, the values in the columns of the foreign key either contain the NULL value or match the primary key values in some row of the primary table. 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. Maybe pg_constaint.condeferrable is appropriate for check_on_commit? I'll appreciate any help Thanks in advance, Emil __________________________________________ Yahoo! DSL – Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com