On Tue 02 Sep 2008 04:06:20 PM EDT, Martin Gainty wrote: > you can use setup a foreign key constraint in your create table so that col= > umn is only populated when > there is a value which syncs to the referenced value > http://www.postgresql.org/docs/7.4/interactive/sql-createtable.html
I don't think that will work. When somebody inserts (99, 98) into product_location, I want to make sure that product ID 99 has the same customer ID as location ID 98. Matt -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
