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