"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> The login was hanging in a simple plpgsql login script which basically
> did an insert/update on a small table. It would hang when called from
> within psql, and once hung the query would not respond to cancel
> requests (such as they are implemented on win32). Investigating
> further, trying to select form this small table at all would also hang.
> Unfortunately, this table tells me which pids are safe to kill and which
> are not,
Did you look at pg_locks or pg_stat_activity?
There is pretty much nothing we can do with this report given the lack
of detail.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
