Thread: Re: [PHP-DB] pg_result_error()

Re: [PHP-DB] pg_result_error()

From
Martin Marques
Date:
El Vie 12 Dic 2003 11:19, Gerard Samuel escribió:
> Im going to CC this to the PostgreSQL list also.
>
> On Friday 12 December 2003 06:44 am, Martin Marques wrote:
> > El Vie 12 Dic 2003 00:09, Gerard Samuel escribió:
> > > What good is this function?
> > > A quick example of the wall Im running into ->
> > > $sql = 'INSERT INTO .....';
> > > $result = pg_query($conn_id, $sql);
> > > if ($result === false)
> > > {
> > >     var_dump( pg_result_error( $result ) );
> >
> > I would use here this:
> >     die(pg_result_error( $result ));
>
> That is fine and all, but my original example was just an example of the
> non functionality of pg_result_error(), not how to handle errors when a
> query fails.
> But for arguement sake, lets use your example in some dummy code[0].
> $result is still boolean false, and pg_result_error() will still return an
> empty string, and using die, would just die, with no report of what
> happened. Then whats the use of pg_result_error().

Looks like you are totally right. Tried it and it works horrible. Any idea on
why this is like this?

P.D.: I had to pass my php4 in Debian to unstable to get a workable (with the
newer capabilities) version. Very annoing, especially becuase I had to pass
apache to unstable as well. :-(

--
 12:13:01 up 16 days, 18:29,  3 users,  load average: 1.32, 0.90, 0.67
-----------------------------------------------------------------
Martín Marqués        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------


Re: [PHP-DB] pg_result_error()

From
Gerard Samuel
Date:
On Friday 12 December 2003 10:24 am, Martin Marques wrote:
> > That is fine and all, but my original example was just an example of the
> > non functionality of pg_result_error(), not how to handle errors when a
> > query fails.
> > But for arguement sake, lets use your example in some dummy code[0].
> > $result is still boolean false, and pg_result_error() will still return
> > an empty string, and using die, would just die, with no report of what
> > happened. Then whats the use of pg_result_error().
>
> Looks like you are totally right. Tried it and it works horrible. Any idea
> on why this is like this?
>

Seems like Im not the only one who thought this function is useless...
http://bugs.php.net/bug.php?id=18747
So Im going to modify my code to not use this function, as it is really a
total waste of time at the moment.
Thanks for the chat...