Re: [HACKERS] SPI example does not work for 7.1beta4

Limin Liu <limin@pumpkinnet.com>

From: Limin Liu <limin@pumpkinnet.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-general@postgresql.org
Date: 2001-03-23T18:30:29Z
Lists: pgsql-hackers
> > ---
> >    SPI_connect();
> >    SPI_exec("create temp table tbl_tmp (n int);",0);
> >    SPI_exec("insert into tbl_tmp values (1);",0);
> >    SPI_finish();
> > ---
> > after InitPostgres and before setsigjmp().
>
> I doubt this will work correctly without a transaction around it ...

Thanks for the hint.  It works fine now between start/finish_xact_command.

--
LM Liu