Martin Koch Andersen wrote:
Chris skrev:
It should be rolled back when a connection is lost or a transaction isn't explicitly committed.

Can you find documentation on this specific issue anywhere?

I think the same as you, but I find it odd, it is not documented.

Reason I'm asking is, I've seen some deadlock issues in a script (using FOR UPDATE and LOCK IN SHARE MODE), that looks like they are caused by transactions not being rolled back (releasing locks) correctly.

This suggests they should be released:

Locks set by IN SHARE MODE and FOR UPDATE reads are released when the transaction is committed or rolled back.

It doesn't explicitly say anything about when a connection is lost but I'm guessing it would rollback the transaction (well I'd sure hope so).

Postgresql & php tutorials

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to