Postgres Pro
Downloads
Home   >   mailing lists

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

From Jasen Betts
Subject Re: FK violation on (emtpy) parent table
Date
Msg-id j3vhsc$abf$1@reversiblemaps.ath.cx
Whole thread Raw
In response to FK violation on (emtpy) parent table  (Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org>)
List pgsql-general
Tree view 
On 2011-08-11, Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org> wrote:
> 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?

AFAIK "you can't" and "no".


--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: md5 of table
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Parameterized prepared statements