Dead locks - Mailing list pgsql-general

From Aristide Aragon
Subject Dead locks
Date
Msg-id 20010506181906.C24365@busa.lionking.org
Whole thread Raw
Responses Re: Dead locks  (Alfred Perlstein <bright@wintelcom.net>)
Re: Dead locks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello
This question isn't about deadlocks, instead, it's about something I've been wondering because of a program I'm doing
thatuses locks. 
My progrm uses begin and commit (or rollback) and locks a table in exclusive mode. What'd happen if the program
unexpectedlydied? How would the database recover from a lock without a commit or rollback? Would the database release
thelock automatically, would it be in deadlock or would I have to release it by hand, and if so how? 

Cheers

Aristide

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: I lost the pg_control file
Next
From: Alfred Perlstein
Date:
Subject: Re: Dead locks