Обсуждение: 'Create table if not exists as' breaks SPI_execute

Поиск
Список
Период
Сортировка

'Create table if not exists as' breaks SPI_execute

От
Stas Kelvich
Дата:
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


Вложения

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

От
Stas Kelvich
Дата:
> 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

От
Tom Lane
Дата:
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