Failure to COMMIT -- Timeout?

From: Ben Lanson <lanson(at)bellatlantic(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Failure to COMMIT -- Timeout?
Date: 2000-08-26 09:08:28
Message-ID: 200008260908.FAA25922@smtp-out2.bellatlantic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Looking through the documentation, I can't find anything that tells me what
happens if an explicitly defined transaction fails to commit. I am
assuming that there must be some timeout, otherwise this obviously causes
the potential for serious problems with locks. For example:

Transaction 1:
BEGIN WORK
UPDATE table
(network outage prevents a COMMIT)

If I am reading correctly, all other transactions will hang waiting to see
if Transaction 1 commits. In this situation it should clearly rollback.
Will postgres eventually time out the transaction and catch this problem?
Can anyone supply or point me to more information about how Postgres
handles this situation?

Testing in psql shows that the transaction is considered stopped (and
rolled back) when the connection from psql is broken. Is a broken network
link (in this case established in PHP) an equivalent situation?

Thanks,
Ben

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Fredrick Bartlett 2000-08-26 16:04:04 Simple question
Previous Message Sherwin Daganato 2000-08-26 07:44:01 serial data type limit