Thread: referential integrity and permissions

referential integrity and permissions

From
Helge Bahmann
Date:
I have a table "foo" which is publically readable.

A second table "bar" contains a foreign key referencing a column in
foo. This table ought to be publically writable.

Whenever I try to insert into "bar", I get the message:
ERROR:  foo: Permission denied.

Why?!?

(This is postgres version 7.0)

Regards,
Helge