Amit Kapila escribió: > On Thursday, November 08, 2012 8:07 PM Alvaro Herrera wrote:
> >The other way to > > define this would be to have a lock that you grab and keep until end of > > transaction, and the .auto.lock file is deleted if the transaction is > > aborted; so have the .auto.lock -> .auto rename only happen at > > transaction commit. > > Is this behavior sane for Transaction block, as in transaction block some > other backend might need to wait > for little longer, if both issued a command to change config parameter? IMO yes, it's sane to make the second backend wait until the first one commits. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers