Postgres Pro
Downloads
Home   >   mailing lists

Re: new RETURNING clause and Pg.pm - Mailing list pgsql-general

From Tom Lane
Subject Re: new RETURNING clause and Pg.pm
Date
Msg-id 18205.1214500726@sss.pgh.pa.us
Whole thread Raw
In response to new RETURNING clause and Pg.pm  ("Brandon Metcalf" <bmetcalf@nortel.com>)
Responses Re: new RETURNING clause and Pg.pm  ("Brandon Metcalf" <bmetcalf@nortel.com>)
List pgsql-general
Tree view 
"Brandon Metcalf" <bmetcalf@nortel.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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: ERROR: could not open relation with OID 2836
Next
From: "Brandon Metcalf"
Date:
Subject: Re: new RETURNING clause and Pg.pm