referential integrity and permissions - Mailing list pgsql-novice

From Helge Bahmann
Subject referential integrity and permissions
Date
Msg-id Pine.LNX.4.21.0008150428581.1937-100000@lothlorien.stunet2.tu-freiberg.de
Whole thread Raw
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Jesus Aneiros
Date:
Subject: Re: kdevelop -> libpq-fe.h
Next
From: "Robert D. Nelson"
Date:
Subject: RE: Installation Problem