Re: [SQL] REFERENCES and INHERITS restrictions?

2008-02-27 Thread Gregory Stark
"Stefan Scheidegger" <[EMAIL PROTECTED]> writes: > Why is this not possible? It seems that this is about inheritance. When I > reference directly to tbl_child1, everything works just fine. I'm afraid inheritance doesn't work with foreign key references. You can have references to specific tables

[SQL] REFERENCES and INHERITS restrictions?

2008-02-27 Thread Stefan Scheidegger
Hi all I’m confronted with the following problem: I have a base table with several child tables which also use the parent’s primary key as their own primary key: CREATE TABLE tbl_parent ( p_id serial NOT NULL, p_time timestamp(6) with time zone NOT NULL DEFAULT '1970-01-01 01:00:00+01'::