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

Thanks Tom,

By the way, did you change the whole archetecture of SPI invocation?

I put
---
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().
This works perfectly in my 7.03 and earlier version. That means, after authentication, we
will have a temp table per each db connection. User can use the client program to "select"
or "insert" upon this temp table.

However, the same code does not work in 7.1. Actually, I got some messages contradicting to
each other:
---
db1=> select * from tbl_tmp;
ERROR: Relation 'tbl_tmp' does not exist
db1=> create temp table tbl_tmp (n int);
ERROR: Relation 'tbl_tmp' already exists
db1=>
---

Can you please give us some hints on what's going on here?

Thanks

Tom Lane wrote:

> Limin Liu <limin(at)pumpkinnet(dot)com> 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 my 7.1 beta4.
>
> Hm. textout() can't be called that way anymore --- as indeed your compiler
> should have told you, if it's any good at all. I get
>
> execq.c: In function `execq':
> execq.c:13: warning: passing arg 1 of `textout' from incompatible pointer type
> execq.c:13: warning: passing arg 1 of `SPI_exec' makes pointer from integer without a cast
>
> Looks like the example is in need of update. Thanks for the report.
>
> regards, tom lane

--
LM Liu