From: | "Davor J(dot)" <DavorJ(at)live(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Referencing to system catalog problem |
Date: | 2010-01-23 14:15:36 |
Message-ID: | hjf0em$2j40$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am logged in as superuser. I am trying to create something similar to
this:
Code:
CREATE TABLE tbl_unit_convfunctions(
unit_from integer REFERENCES tbl_units (unit_id),
unit_to integer REFERENCES tbl_units (unit_id),
proc_id oid REFERENCES pg_proc (oid)
)but no matter what I refer to from pg_proc, i get the error message:
ERROR: permission denied: "pg_proc" is a system catalog
SQL state: 42501
Has anyone any suggestions how to do something similar, or even better: how
to solve this error. I couldn't find any useful information on the net about
this issue.
Thanks,
Davor
Original post:
http://forums.devshed.com/postgresql-help-21/referencing-to-system-catalog-problem-670063.html
Note: OID's are unique in that table, and should be referable, and I
explicitely granted the REFERENCE priviledge to the superuser.
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2010-01-23 15:51:28 | Re: Old/New |
Previous Message | Alan Millington | 2010-01-23 13:26:22 | Re: Error "invalid byte sequence for encoding UTF8" on insert into BYTEA column |