referential integrity and permissions

From: Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: referential integrity and permissions
Date: 2000-08-15 02:34:59
Message-ID: Pine.LNX.4.21.0008150428581.1937-100000@lothlorien.stunet2.tu-freiberg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Robert D. Nelson 2000-08-15 13:12:00 RE: Installation Problem
Previous Message Jesus Aneiros 2000-08-15 00:18:06 Re: kdevelop -> libpq-fe.h