Re: transaction timeout

> OK, for the third or fourth time, what kind of locks
> is your application
> taking out that can lock the whole database?

I'd like to know that myself. How can a
select/inser/update lock an entire table or even
multiple tables?

> How, exactly, can PostgreSQL (or any other database)
> recognize a hung
> client versus one that's waiting for an hour on user
> input?

transaction timeout. In our application, one hour-long
transaction is not normal. I want it to abort
automatically.

> Yes, tell us what you're doing that "locks the whole
> database".

I wish I knew. Last sunday it was locked so bad that
even selects were blocked until we killed the
offending client.

Eugene

____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs