On 13/11/2019 06:13, Andres Freund wrote:
> Hi,
>
> On 2019-11-13 05:09:31 +0000, Tom Mercha wrote:
>> I've been using SPI to execute some queries and this time I've tried to
>> issue CREATE TABLE commands through SPI. I've been getting the message
>> "ERROR: CREATE TABLE AS is not allowed in a non-volatile function".
>
> Any chance you're specifying read_only = true to
> SPI_execute()/execute_plan()/...?
>
> Greetings,
>
> Andres Freund
>
Dear Andres
That's exactly what's up! Everything is working as intended now. So
sorry this was a bit silly of me, I didn't understand the message as a
reference to that configuration.
Thanks so much.
Best regards
Tom