From: | <david(at)andl(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query? |
Date: | 2016-04-21 01:24:03 |
Message-ID: | 005401d19b6c$81ca5830$855f0890$@andl.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> >> 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?
Of course. Every SPI call is checked and any unexpected error is trapped,
resulting eventually in a call to elog(ERROR).
The sequence I provided is a CREATE TABLE followed by an INSERT. The table
is successfully created with the correct contents.
Regards
David M Bennett FACS
Andl - A New Database Language - andl.org
From | Date | Subject | |
---|---|---|---|
Next Message | Karl Czajkowski | 2016-04-21 01:37:53 | Re: RLS policy dump/restore failure due to elided type-casts |
Previous Message | Tom Lane | 2016-04-21 01:17:20 | Re: RLS policy dump/restore failure due to elided type-casts |