lost in system tables

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-sql by date

  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