hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> apparently revoking update rights on referencing table blocks deletes on
> master table:
>> revoke update on b from test;
> REVOKE
>> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
