Yes, you cannot currently do this. Check past discussions on mailing
lists for more details. Inheritance and constraints is pretty dodgy
right now (for instance, Reservationfile.datafileNr is not unique).
On Tue, 5 Jun 2001, Mikael Kjellström wrote:
> I've declared a foreign key in table FileId referencing the primary key in
> Datafile. Datafile in itself does'nt have any rows, but Reservationfile,
> inheriting from Datafile has.
>
> I can't insert a row in FileId because no row is found in Datafile: this is
> not what I expected.
>
> I've tried suffixing Datafile with an asterisk (even though that shouldn't
> be necessary in 7.1), but that's not valid syntax.
>
> I'm running 7.1.release4 on Debian Woody.
>
> Table definitions for clarity:
>
> -- Has no rows of its own
> declare Datafile (
> datafileNr not null primary key
> );
> -- This one has rows
> declare Reservationfile (
> )
> inherits(Datafile)
> ;
> declare FileId (
> datafileNr not null
> references Datafile
> );
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
