[BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database

2008-05-21 Thread TIAN Justin
Hi, I met an error, when psql client version is 8.1.4, I use it to connect to remote database or local database, such as "psql -U name -p -d -h ", it will prompt error message "psql: expected authentication request from server, but received ", but if the client version is 8.0.3, there is no p

Re: [BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database

2008-05-21 Thread Heikki Linnakangas
TIAN Justin wrote: I met an error, when psql client version is 8.1.4, I use it to connect to remote database or local database, such as "psql -U name -p -d -h ", it will prompt error message "psql: expected authentication request from server, but received ", but if the client version is 8.0.3,

[BUGS] Getting the command line to work

2008-05-21 Thread Paul Jordan
Hi. Perhaps this isn't the proper place to send this, but it's the only address I have. I've installed postgres and I'm trying to use the command prompt to create a database (PGAdmin III having failed miserably at the task). The documentation I'm working with, created by people I trust know what th

Re: [BUGS] Getting the command line to work

2008-05-21 Thread Dave Page
On Wed, May 21, 2008 at 6:43 PM, Paul Jordan <[EMAIL PROTECTED]> wrote: > Hi. Perhaps this isn't the proper place to send this, but it's the only > address I have. I've installed postgres and I'm trying to use the command > prompt to create a database (PGAdmin III having failed miserably at the > t

[BUGS] Deadlock condition in driver

2008-05-21 Thread Daniel Migowski
Hello dear developers, I came across a deadlock condition in the JDBC driver that rises when very large queries, containing thousends of statements are send to the server with statement.execute(). I need this functionality, which work well with less than 6445 statements to send update scripts

Re: [BUGS] Deadlock condition in driver

2008-05-21 Thread Kris Jurka
On Wed, 21 May 2008, Daniel Migowski wrote: I came across a deadlock condition in the JDBC driver that rises when very large queries, containing thousends of statements are send to the server with statement.execute(). We already consider this case for batch execution and break the batch int

[BUGS] BUG #4186: set lc_messages does not work

2008-05-21 Thread Thomas H
The following bug has been logged online: Bug reference: 4186 Logged by: Thomas H Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Windows 2003 Description:set lc_messages does not work Details: the patch discussed here [1] that supposedl

Re: [BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database

2008-05-21 Thread TIAN Justin
Heikki Linnakangas, Thanks for your quick response; the server we used is 8.1.4, The error when using client 8.1.4, > psql -U or -p -d testdb -h localhost Output: psql: expected authentication request from server, but received when used 8.0.3, no problem, > psql -U or -p -d testdb -h l

Re: [BUGS] Deadlock condition in driver

2008-05-21 Thread Richard Evans
We hit this problem and modified the driver to use non-blocking IO to fix it. You lose some of the more unusual features of the driver (such as switching the socket after open), but it does fix the blocking. Richard Evans On Wed, 21 May 2008, Daniel Migowski wrote: I came across a deadlock

Re: [BUGS] Deadlock condition in driver

2008-05-21 Thread Kris Jurka
Previously we did not want to move to nio to be able to support older JDK versions, but with the next major release we're ready to drop that support. If you have this code, I'd certainly be interested in looking at it. One of the big drawbacks of breaking up a single execute call into multi