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

[sasa su]

Thanks barwick,

 

Is the process crash also expected,

 

And dose anyone considered enhancing this API?

 

05.02.2021, 10:55, "Ian Lawrence Barwick" <barw...@gmail.com>:

2021年2月5日(金) 11:38 sasa su <i...@sasa.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