Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> I don't. It's from the interlock that prevents copying a database that
>> contains active sessions.
> I understand that, but why does psql still hold that lock while
> displaying the database names with more?
I don't think it closes the database connection until it's ready to
exit.
We could maybe fix -l to close the connection before outputting data,
but it doesn't seem like that really will make a lot of difference.
What of someone who's connected to template1 with a plain "psql
template1" session?
regards, tom lane