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
