From: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Foreign keys: how to turn referential integrity constraint off |
Date: | 2002-08-23 05:09:50 |
Message-ID: | 3D65C39E.60505@mega-bucks.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-08-23 05:41:41 | Re: Foreign keys: how to turn referential integrity |
Previous Message | Tom Lane | 2002-08-23 04:15:53 | Re: Controling Rule's Firing Order |