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
|
Список | 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 по дате отправления: