Alban Hertroys <dal...@solfertje.student.utwente.nl> writes:
> FOREIGN KEY (base, true) REFERENCES unitclass (name, is_baseclass),
> FOREIGN KEY (derived, false) REFERENCES unitclass(name, is_baseclass)
> I can of course add a few triggers to force that constraint, but I think it
> would be nice if the above syntax could be made to work. Or is this already
> in 8.4 or 8.5 or is this a can of worms? Does the SQL spec disallow it?
Yes. FK constraints have to be columns vs. columns --- otherwise they
can't be represented in the information_schema views.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
