"Merlin Moncure" <merlin.moncure@rcsonline.com> 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