Amit Kapila escribió:
> 3. Two backends trying to write to .auto file
> we can use ".auto.lock" as the the lock by trying to create it in
> exclusive mode as the first step
> of the command. If it already exists then backend needs to wait.
So changing .auto settings would be nontransactional? 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.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
