Re: PL/Perl: spi_prepare() and RETURNING - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/Perl: spi_prepare() and RETURNING
Date
Msg-id 13299.1156722584@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/Perl: spi_prepare() and RETURNING  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: PL/Perl: spi_prepare() and RETURNING
List pgsql-hackers
"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> On 8/24/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> This reminds me of a consideration I had been intending to bring up on
>> the mailing lists: what exactly do we want to do with the SPI API for
>> RETURNING queries?

> I like adding RETURNING-specific return codes.

>> Another issue I noted in that same area is that spi.c does not set
>> SPI_processed for a utility statement, even if the utility statement
>> returns tuples.  Is this a bug, or should we leave it alone?

> I think it's a bug.

I've applied a patch along these lines.  David's plperl example now does
what (I think) he expected.  Does anyone want to extend the plperl,
pltcl, plpython regression tests to check behavior with INSERT RETURNING
etc?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: integration of pgcluster into postgresql
Next
From: Chahine Hamila
Date:
Subject: Re: integration of pgcluster into postgresql