Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
