Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign keys and access privileges - Mailing list pgsql-sql

From Tom Lane
Subject Re: Foreign keys and access privileges
Date
Msg-id 23410.958661686@sss.pgh.pa.us
Whole thread Raw
In response to Foreign keys and access privileges  (mkresse@slyde.in-berlin.de)
Responses Re: Foreign keys and access privileges  (mkresse@slyde.in-berlin.de)
List pgsql-sql
Tree view 
mkresse@slyde.in-berlin.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using substr with user defined types
Next
From: Tom Lane
Date:
Subject: Re: Re[2]: lower() for varchar data by creating an index