From: | Emil Rachovsky <zsevgymko(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | lost in system tables |
Date: | 2005-12-06 15:47:55 |
Message-ID: | 20051206154755.86057.qmail@web54314.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Fuchs | 2005-12-06 16:18:11 | Re: Query SELECT * sehr langsam |
Previous Message | Axel Loder | 2005-12-06 15:47:33 | Query SELECT * sehr langsam |
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Pireddu | 2005-12-06 16:34:59 | Re: lost in system tables |
Previous Message | Lane Van Ingen | 2005-12-06 15:10:55 | Re: Database with "override" tables |