Re: [SQL] Strategy for unlocking query

2001-04-04 Thread Tom Lane
"Graham Vickrage" <[EMAIL PROTECTED]> writes: > I have just done a rather large transaction via a telnet/psql session which > executed OK. The problem occured when the telnet session timed out before I > could commit the rows. > This must have locked the rows in question because when I tried to v

[SQL] Strategy for unlocking query

2001-04-04 Thread Graham Vickrage
I have just done a rather large transaction via a telnet/psql session which executed OK. The problem occured when the telnet session timed out before I could commit the rows. This must have locked the rows in question because when I tried to vacuum the table it just hung. What is the best way of