Jonathan Hedstrom <[EMAIL PROTECTED]> writes:
> Does anyone know if it is possible to use system catalogs in foreign key
> constraints in Postgres 7.4.1?
It's not. The system wouldn't enforce the constraint even if you
overrode the permission check, because internal backend catalog updates
don't
Does anyone know if it is possible to use system catalogs in foreign key
constraints in Postgres 7.4.1?
My sample table:
*
CREATE TABLE tbl_reference (
reference_id SERIAL PRIMARY KEY,
from_table NAME NOT NULL REFERENCES pg_catalog.pg_class(relname),
from_id INTEGER,
to_table NAME NOT NULL REFERE
