Re: [GENERAL] FK violation on (emtpy) parent table

2011-09-04 Thread Jasen Betts 
On 2011-08-11, Louis-David Mitterrand vindex+lists-pgsql-gene...@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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] FK violation on (emtpy) parent table

2011-08-11 Thread Louis-David Mitterrand 
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,

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general