Foreign keys: how to turn referential integrity constraint off

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

Responses

Browse pgsql-general by date

  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