Francisco Reyes <lists(at)natserv(dot)com> writes:
>> Did you look to see whether your old session had disconnected or not?
> How would I see this from within psql?
Right now I think "ps" on the server machine is the only viable way.
In 7.2 the pg_stat_activity table would give you a clue, at least.
You might care to read
http://candle.pha.pa.us/main/writings/pgsql/sgml/monitoring.html
which is from 7.2 docs, but the info about using ps applies to 7.1.
regards, tom lane