FK violation on (emtpy) parent table

From: Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: FK violation on (emtpy) parent table
Date: 2011-08-11 17:27:42
Message-ID: 20110811172742.GA9741@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-08-11 18:47:22 Filling Missing Primary Key Values
Previous Message Diego Augusto Molina 2011-08-11 17:14:25 Re: is max connections in a database table somewhere