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 REFERENCES pg_catalog.pg_class(relname),
to_id INTEGER
);*
The error I get when I try to create the table:
*ERROR: permission denied for relation pg_class*
If this is a permission issue, I already have SELECT permissions on
pg_class...any ideas as to what sort of permissions need to be granted
to accomplish this?