Re: [GENERAL] please! SPI_finish is strange

2007-08-15 Thread Tom Lane
"=?EUC-KR?B?vK2x4ryu?="<[EMAIL PROTECTED]> writes: > Please help me to solve the problem.(Sorry, I'm not good at english > speeking) This code has no chance of working --- you cannot hold an SPI context open across multiple calls to an SRF. Run the SPI query to completion during the FIRSTCALL se

[GENERAL] please! SPI_finish is strange

2007-08-15 Thread 서기석
this source is strange,   when I uncomment code(1), and compile, and, run query   d_cppschool=> SELECT * FROM UC_ExecWithNo('SELECT I_IDNum,I_UserID FROM DI_ID',10,10,3) as T(T1 int,T2 bigint,T3 CHAR(20))   and I get result :  WARNING: transaction left non-empty SPI stack Hint: Check for missing "S