Re: [GENERAL] hi, how to let the inserted tuple visible to other backend when current backend hasn't finish?

2010-09-13 Thread Merlin Moncure
On Sun, Sep 12, 2010 at 3:02 AM, sunpeng wrote: > hi, These codes are in the postgresql engine, just assume they are in > PortalRun() function: > //1.create table structure > char *relname = "test"; > ... > relOid = heap_create_with_catalog(relname, ); > CommandCounterIncrement(); > ... > //2.

[GENERAL] hi, how to let the inserted tuple visible to other backend when current backend hasn't finish?

2010-09-12 Thread sunpeng
hi, These codes are in the postgresql engine, just assume they are in PortalRun() function: //1.create table structure char *relname = "test"; ... relOid = heap_create_with_catalog(relname, ); CommandCounterIncrement(); ... //2.then i can use SPI_execute to create index on this created table SP