From: Emil Rachovsky <zsevgymko@yahoo.com>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: lost in system tables
Date: Tue, 6 Dec 2005 07:47:55 -0800 (PST)
Message-ID: <20051206154755.86057.qmail@web54314.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: zsevgymko@yahoo.com, pgsql-general@postgresql.org
Subject: Re: lost in system tables
In-Reply-To: <20051206154755.86057.qmail@web54314.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox