[openstreetmap/openstreetmap-website] Lock changesets during a diff upload (PR #6379)

[Tom Hughes]

tomhughes left a comment (openstreetmap/openstreetmap-website#6379)

If you're not in an explicitly started transaction then each statement is executed in a transaction that is then immediately committed so the lock would release at the end of the statement. See https://www.postgresql.org/docs/17/sql-begin.html:

> By default (without BEGIN), PostgreSQL executes transactions in “autocommit” mode, that is, each statement is executed in its own transaction and a commit is implicitly performed at the end of the statement (if execution was successful, otherwise a rollback is done).

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/6379#issuecomment-3346341395
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/6379/c3346341395 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250929/39441513/attachment.htm>