Re: please! SPI_finish is strange

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 서기석 <akbar(at)korea(dot)com>
Cc: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Subject: Re: please! SPI_finish is strange
Date: 2007-08-16 02:31:41
Message-ID: 14827.1187231501@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"=?EUC-KR?B?vK2x4ryu?="<akbar(at)korea(dot)com> writes:
> <P>Please help me to solve the problem.(Sorry, I'm not good at english speeking)</P>

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 setup, and stash the results someplace safe.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Manes 2007-08-16 03:32:28 Re: Writing most code in Stored Procedures
Previous Message Mohd Kamal Bin Mustafa 2007-08-16 02:23:37 Re: Writing most code in Stored Procedures