Strategy for unlocking query - Mailing list pgsql-sql

From Graham Vickrage
Subject Strategy for unlocking query
Date
Msg-id NDBBJABDILOPAOOMFJHOGEAJCJAA.graham@digitalplanit.com
Whole thread Raw
Responses Re: Strategy for unlocking query
List pgsql-sql
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 dealing with this problem as I ended up stopping and
restarting the postmaster?

Also are functions within functions dealt with in a 'transactional' sense?

Cheers

Graham

Attachment

pgsql-sql by date:

Previous
From: "tjk@tksoft.com"
Date:
Subject: Re: outer joins
Next
From: Tom Lane
Date:
Subject: Re: Query broken under 7.1RC2