> > ---
> >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
Limin Liu <[EMAIL PROTECTED]> writes:
> By the way, did you change the whole archetecture of SPI invocation?
No, I told you: what's broken here is the textout() call. Attached
is the updated example.
> I put
> ---
>SPI_connect();
>SPI_exec("create temp table tbl_tmp (n int);",0);
>S
Limin Liu <[EMAIL PROTECTED]> writes:
> I am learning and using SPI. In PostgreSQL documentation chapter "Server
> Programming Interface," there is a small example name "execq(text,
> int)".
> This example works as the document says on 7.0.3 and earlier version,
> but this example DOES NOT work on
