Hello,
My problem:
1. I have a application accessing Postgres 8.2 using NHibernate 3.
2. Using hibernate I lock a registry using the function '
nhibernate.lockmode.upgradenowait'. Ok, its worked.
3. I remove my ethernet cable and lost the connection with Postgres.
4. The registry I locked before remove the cable, continue locked forever!
Question:
How can Postgres detect the connection lost and remove all locks made by
this connection? It's a configuration in Postgres or have another way to
lock a registry?
Thanks.