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

2011-09-04 Thread Jasen Betts
On 2011-08-11, Louis-David Mitterrand 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 anothe

[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 mailin