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