hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> apparently revoking update rights on referencing table blocks deletes on master table:
>> revoke update on b from test;
>> delete from a where id = 1;
> ERROR: permission denied for relation b
> CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."b" x WHERE $1 OPERATOR(pg_catalog.=) "a_id" FOR SHARE OF x"
Hmm. I wonder why we are bothering with FOR SHARE locks on the
referencing table, when we don't have any intention to change
those rows. Is there some race condition that's needed to prevent?
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Adam Hardy||Date: 2008-01-22 23:42:17|
|Subject: BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name|
|Previous:||From: Tom Lane||Date: 2008-01-22 17:42:58|
|Subject: Re: why provide cross type arithmetic operators |