Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group