Foreign keys: how to turn referential integrity constraint off

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема Foreign keys: how to turn referential integrity constraint off
Дата
Msg-id 3D65C39E.60505@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: Foreign keys: how to turn referential integrity  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I have a table of line_items and distributor_orders somewhat like this:

create table DIST_ORDER (

id                      serial          primary key,
distributor_id          integer         references DISTRIBUTORS(id),
submit_time             timestamp (0) without time zone not null
);

create table MEMBER_INVOICE_LI (

invoice_id              integer         references INVOICE_CART(id),
id                      integer         not null, --line item number
dist_order_id           integer         references DIST_ORDER(id),
prod_id                 char(12)        references PRODUCTS(id),
quantity                int2            not null,
price                   integer         not null,
shipped                 boolean         not null,

primary key (invoice_id, id)
);

The problem I have is that distributor orders are only generated at the
end of the day, so when a customer creates an order, a line item is
created *but* there is no distributor order to assign it to yet.

How can I set the constraint to check referential integrity or let the
value be null?

Is this possible? Is it recommendable?

Thanks

Jc


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Controling Rule's Firing Order
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Foreign keys: how to turn referential integrity