Re: SPI: process exit in SPI_exec when table not exist. error code not return.

2021年2月5日(金) 11:38 sasa su <i(at)sasa(dot)su>:

> Hi.
>
> When running a query with a not exist table in SPI_exec. the process exit
> with -1 in SPI_exec function.
> the error code SPI_ERROR_REL_NOT_FOUND never return.
>
> I made a minimal reproduction code in
> https://github.com/Sasasu/worker_spi_table_not_exist
>
> The core code is:
>
> int spi = SPI_exec("select * from not_exist_table", 0);
> // can not reach here
> Assert(spi == SPI_ERROR_REL_NOT_FOUND);
>

The list of return codes returned by SPI_exec is here:

https://www.postgresql.org/docs/current/spi-spi-execute.html

and doesn't include "SPI_ERROR_REL_NOT_FOUND". The only
function which does return that is SPI_unregister_relation, see:

https://www.postgresql.org/docs/current/spi-spi-unregister-relation.html

Regards

Ian Barwick

--
EnterpriseDB: https://www.enterprisedb.com