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: (view raw, whole thread or download thread mbox)
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.


(This is postgres version 7.0)


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-2017 The PostgreSQL Global Development Group