Postgres Pro
Downloads
Home   >   mailing lists

Thread: 'Create table if not exists as' breaks SPI_execute

'Create table if not exists as' breaks SPI_execute

From
Stas Kelvich
Date:
Hi.

SPI_execute assumes that CreateTableAsStmt always have completionTag == “completionTag”.
But it isn’t true in case of ‘IF NOT EXISTS’ present.




--
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
Attachment

Re: 'Create table if not exists as' breaks SPI_execute

From
Stas Kelvich
Date:
> On 11 Apr 2016, at 18:41, Stas Kelvich <s.kelvich@postgrespro.ru> wrote:
>
> Hi.
>
> SPI_execute assumes that CreateTableAsStmt always have completionTag == “completionTag”.
> But it isn’t true in case of ‘IF NOT EXISTS’ present.
>
>
> <spi-cta.patch>

Sorry, I meant completionTag == “SELECT”.

--
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company

Re: 'Create table if not exists as' breaks SPI_execute

From
Tom Lane
Date:
Stas Kelvich <s.kelvich@postgrespro.ru> writes:
> SPI_execute assumes that CreateTableAsStmt always have completionTag == “completionTag”.
> But it isn’t true in case of ‘IF NOT EXISTS’ present.

Pushed, thanks.
        regards, tom lane