Re: SPI error with non-volatile functions

2019-11-12 Thread Tom Mercha
On 13/11/2019 06:13, Andres Freund wrote: > Hi, > > On 2019-11-13 05:09:31 +, 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 no

Re: SPI error with non-volatile functions

2019-11-12 Thread Andres Freund
Hi, On 2019-11-13 05:09:31 +, 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 specifyi

SPI error with non-volatile functions

2019-11-12 Thread Tom Mercha
Dear Hackers 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". I'm a bit confused because my functions are set as volatile when I got