Thread: FK violation on (emtpy) parent table

FK violation on (emtpy) parent table

From
Louis-David Mitterrand
Date:
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,

Re: FK violation on (emtpy) parent table

From
Jasen Betts
Date:
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