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

2003-07-24 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 m

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

2003-07-24 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> 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

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

2003-07-24 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 > >> correcte

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

2003-07-24 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> 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? > Sorr

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

2003-07-24 Thread Bruce Momjian
Adrian Calvin wrote: > Postgres Version 7.1 > > 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 believ

[BUGS] When "psql -l" is invoked from prompt and not completed, no other user can create a database..

2003-07-24 Thread Adrian Calvin
Postgres Version 7.1 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?     Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web

Re: [BUGS] libpq incompatibility

2003-07-24 Thread Tom Lane
"Admin Gaston" <[EMAIL PROTECTED]> writes: > When the program is running for a while, it finish with segmentation fault = > (core dumped). > #0 0x420742e2 in _int_malloc () from /lib/tls/libc.so.6 > #1 0x4207360b in malloc () from /lib/tls/libc.so.6 > #2 0x400278b3 in PQmakeEmptyPGresult () fro

Re: [BUGS] Small problem in contrib/dbase/dbf2pg.c

2003-07-24 Thread Thomas Behr
Hej! select version(); version -- PostgreSQL 7.3.3 on sparc-sun-solaris2.7, compiled by cc -Xa On 23 Jul 2003, Bruce Momjian wrote: > Thomas, would you send me a context diff (diff

[BUGS] problem with libpq7.3.3/encrypted

2003-07-24 Thread Andreas Pflug
I believe we have a problem with libpq 7.3.3 with encryption. I currently don't have a 7.3.3/ssl system running, but this has been reported by Christian Ruediger Bahls, who traced it, and Dave Page. When running pgAdmin3 over a ssl encrypted connection, it will hang, even for very small queries

[BUGS] libpq incompatibility

2003-07-24 Thread Admin Gaston
Hi, sorry my english. Recently i was using postgresql 7.2, and then i update to 7.3.3. We was running a C program that was working fine with 7.2, but in 7.3.3 it seg fault.   int procesarConsultasSQL(int nCliente){     .. more code     FD_SET(cli->socketDB, &readfds);    timeout.tv_