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