From: Martin Marques <martin@bugs.unl.edu.ar>
To: Gerard Samuel <php-db@trini0.org>
To: php-db@lists.php.net
Cc: pgsql-php@postgresql.org
Subject: Re: [PHP-DB] pg_result_error()
Date: Fri, 12 Dec 2003 12:24:57 -0300
Message-ID: <200312121224.57200.martin@bugs.unl.edu.ar> (raw)
In-Reply-To: <200312120908.18042.php-db@trini0.org>
References: <200312112209.54516.php-db@trini0.org>
<200312120844.16882.martin@bugs.unl.edu.ar>
<200312120908.18042.php-db@trini0.org>
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
-----------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: martin@bugs.unl.edu.ar, php-db@trini0.org, php-db@lists.php.net
Subject: Re: [PHP-DB] pg_result_error()
In-Reply-To: <200312121224.57200.martin@bugs.unl.edu.ar>
References: <200312112209.54516.php-db@trini0.org> <200312120844.16882.martin@bugs.unl.edu.ar> <200312120908.18042.php-db@trini0.org> <200312121224.57200.martin@bugs.unl.edu.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox