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?

begin:vcard
fn:Jonathan Hedstrom
n:Hedstrom;Jonathan
org:Downtown Emergency Service Center;Information Services
email;internet:[EMAIL PROTECTED]
title:Data Systems Administrator
tel;work:(206) 464-1570 ext. 3014
version:2.1
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to