Thanks Tom. I found the relevant bit of code in the psql files. Looks like it's just a simple loop that compares the error with the phrase "fe_sendauth: no password supplied" and then prompts for the password and tries again. Of course, if someone in the future decides to change the error message, then the code gets broke. I doubt that's likely however.
-Tony ----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "Tony Reina" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, June 28, 2004 12:12 AM Subject: Re: [ADMIN] Password with libpq > [EMAIL PROTECTED] (Tony Reina) writes: > > However, what about in the general case where my client program > > doesn't know if a password is required or not. Is there any libpq > > function to query the server if a password is required? Perhaps, > > there's a return value for PQconnectdb which would tell me that the > > connection failed because of the password? (In which case, I can ask > > for the password and try the connection again.) > > Look into the psql source code; it does essentially this. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
