Re: Foreign keys and access privileges

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mkresse(at)slyde(dot)in-berlin(dot)de
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Foreign keys and access privileges
Date: 2000-05-18 14:54:46
Message-ID: 23410.958661686@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

mkresse(at)slyde(dot)in-berlin(dot)de writes:
> Now, with Postgres 7.0 RC1, when some user (not the owner of the
> db, of course) tries to update, change or insert anything into
> choice, he gets an error message that says 'Permission denied' for
> table users.

IIRC this is a known bug in RC1 (permissions not handled correctly
for foreign key references). Have you tried it in 7.0 final?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-05-18 15:00:47 Re: Re[2]: lower() for varchar data by creating an index
Previous Message Tom Lane 2000-05-18 14:52:57 Re: Using substr with user defined types