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