Postgres Pro
Downloads
Home   >   mailing lists

FK violation on (emtpy) parent table - Mailing list pgsql-general

From Louis-David Mitterrand
Subject FK violation on (emtpy) parent table
Date
Msg-id 20110811172742.GA9741@apartia.fr
Whole thread Raw
List pgsql-general
Tree view 
Hi,

I have an empty parent 'price' table with several partitioned child
tables that contain the actual data.

How can I reference the parent 'price' table in a FK? When I try I get a
FK violation. Is that expected behavior? Is there another way to do it?

Thanks,

pgsql-general by date:

Previous
From: Diego Augusto Molina
Date:
Subject: Re: is max connections in a database table somewhere
Next
From: Rich Shepard
Date:
Subject: Filling Missing Primary Key Values