Match Full on foreign Key

Поиск
Список
Период
Сортировка
От sl26@ukc.ac.uk (Marc Richards)
Тема Match Full on foreign Key
Дата
Msg-id 8a5911e.0302090926.46a657c2@posting.google.com
обсуждение исходный текст
Список pgsql-general
I have defined the following foreign keys in a table:

*********
FOREIGN KEY (staff_login) REFERENCES staff (staff_login) MATCH FULL ON
DELETE CASCADE ON UPDATE CASCADE,

    FOREIGN KEY (module_code) REFERENCES module (module_code) MATCH FULL
ON DELETE CASCADE ON UPDATE CASCADE,
*********

these two fields make the primary key of the table in which they are
in.

MATCH FULL will not allow one column of a multi-column foreign key to
be NULL unless all foreign key columns are NULL...so:

*If an entry is made in "staff_login" from the "staff" table that it
references, then "module_code" will be empty until the user enters a
value for that field in the "module" table.  Will having MATCH FULL on
*both* keys present problems them when users fill in their details?
Should I just have MATCH FULL on one field or even on none at all and
have my web application (which feeds data into the DB) check this
instead?

Comments appreciated,
Cheers.

В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: question about managing multiple databases
Следующее
От: gl_nospam@earthlink.net (Greg Laird)
Дата:
Сообщение: Postgres Windows ADO help needed