Skip site navigation (1) Skip section navigation (2)

Re: new RETURNING clause and Pg.pm

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: new RETURNING clause and Pg.pm
Date: 2008-06-26 17:18:46
Message-ID: 18205.1214500726@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Brandon Metcalf" <bmetcalf(at)nortel(dot)com> writes:
> I just upgraded to 8.3.3 and taking advantage of the RETURNING clause
> which is really cool.  I've found that with Pg.pm $r->resultStatus
> returns the integer "2" when the RETURNING clause is used on an
> insert.

> Of course, without using RETURNING the status is the constant
> PGRES_COMMAND_OK.

Sounds to me like a bug in Pg.pm --- it's probably not expecting
a result to come back from an INSERT.  You oughta nag its author
about that.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: robDate: 2008-06-26 17:20:58
Subject: libpq block allocated before my malloc handler inits?
Previous:From: Alban HertroysDate: 2008-06-26 17:13:26
Subject: Re: ERROR: could not open relation with OID 2836

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group