Re: Insufficient locking for ALTER DEFAULT PRIVILEGES - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Insufficient locking for ALTER DEFAULT PRIVILEGES
Date
Msg-id 20150621144524.GF133018@postgresql.org
Whole thread Raw
In response to Re: Insufficient locking for ALTER DEFAULT PRIVILEGES  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Insufficient locking for ALTER DEFAULT PRIVILEGES  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Alvaro Herrera wrote:

> Now that I actually check with a non-relation object, I see pretty much
> the same error.  So probably if instead of some narrow bug fix what we
> need is some general solution for all object types.  I know this has
> been discussed a number of times ...  Anyway I see now that we should
> not consider this a backpatchable bug fix, and I'm not doing the coding
> either, at least not now.

Discussed this with a couple of 2ndQ colleagues and it became evident
that MVCC catalog scans probably make this problem much more prominent.
So historical branches are not affected all that much, but it's a real
issue on 9.4+.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: get_relation_info comment out of sync
Next
From: Peter Eisentraut
Date:
Subject: Re: 9.5 make world failing due to sgml tools missing