Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query? - Mailing list pgsql-general

From Tom Lane
Subject Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query?
Date
Msg-id 7687.1461162513@sss.pgh.pa.us
Whole thread Raw
In response to Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query?  (<david@andl.org>)
Responses Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query?
List pgsql-general
<david@andl.org> writes:
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>> Define "executes".  You could shove those lines in via the wire protocol,
>> sure, but SPI won't take them.

> Now you really have me puzzled. What I provided is an extract from the log
> of generated SQL commands sent to the SPI interface. [Obviously there also
> values bound to the parameters which do not show up here.]

> The code executes without error and produces exactly the output I expected.

Are you remembering to check the result code from SPI_execute_whatever?

            regards, tom lane


pgsql-general by date:

Previous
From: Moreno Andreo
Date:
Subject: Re: PG 9.1 on windows setup problem
Next
From: Alex Ignatov
Date:
Subject: Re: Initdb --data-checksums by default