Re: [BUGS] When "psql -l" is invoked from prompt and not completed,

#1

Bruce Momjian <pgman (AT) candle (DOT) pha.pa.us> writes:

Quote:

Adrian Calvin wrote:
When "psql -l" is invoked from prompt, and a user lets it sit
at the 'more' prompt, no other user can create a database. The
"cannot access template..." error is thrown. Has this been
corrected in later versions?

Sorry, I have trouble believing that.

I don't. It's from the interlock that prevents copying a database that
contains active sessions.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#2

Tom Lane wrote:

Quote:

Bruce Momjian <pgman (AT) candle (DOT) pha.pa.us> writes:
Adrian Calvin wrote:
When "psql -l" is invoked from prompt, and a user lets it sit
at the 'more' prompt, no other user can create a database. The
"cannot access template..." error is thrown. Has this been
corrected in later versions?

Sorry, I have trouble believing that.

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 thought the database was
shipped to the client, and the locks released.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

#3

Tom Lane wrote:

Quote:

Bruce Momjian <pgman (AT) candle (DOT) pha.pa.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?

Oh, so it is their connection to template1 that is causing the lock, not
the display of the -l data. Thanks, got it, and makes sense.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] When "psql -l" is invoked from prompt and not completed,

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] When "psql -l" is invoked from prompt and not completed, - 07-24-2003 , 04:33 PM

Re: [BUGS] When "psql -l" is invoked from prompt and not completed, - 07-24-2003 , 04:56 PM

Re: [BUGS] When "psql -l" is invoked from prompt and not completed, - 07-24-2003 , 05:15 PM