[SQL] Foreign key referencing subclasses.

[Johannes Grødem]

Hi,

it seems I can't have a foreign key that references some subclass.  Postgres
says it can't figure out what its primary key is.  The primary key is defined
in the superclass.

I have something like this:

CREATE TABLE resource_record(
  rrid SERIAL
  -- etc.
);

CREATE TABLE soa_record(
  -- blah, blah
) INHERITS(resource_record);

CREATE TABLE domain(
  -- ...
  soaid REFERENCES soa_record  -- *
);


* = This doesn't work. I can reference resource_record here, but I can not
    reference soa_record that way. Referencing resource_record* doesn't work
    either.

-- 
johs

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])