Re: PHP pg_connect

On 17.07.2007 09:13, Vince wrote:
> When this fails, I get a useful error print:
>
> $dbconn = pg_connect($connection_str);
>
> Ouput:
>
> Warning: pg_connect() [function.pg-connect]: Unable to connect to
> PostgreSQL server: FATAL: password authentication failed for user
> "postgres1" in ...
>
> How do I capture this error and handle the printing myself?  I want to
> be able to know why it failed... ie password in this case.

This is a PHP, not a PostgreSQL question.

if (!pg_connect()) {
   if (preg_match('/authentication\sfailed/', pg_last_error())) {
     echo "Oh dear, you lost your password?\n";
   } else if (true) {
     echo "OMG, something else went wrong!\n";
   }
}


--
Regards,
Hannes Dorbath