Postgres Pro
Downloads
Home   >   mailing lists

Re: please! SPI_finish is strange - Mailing list pgsql-general

From Tom Lane
Subject Re: please! SPI_finish is strange
Date
Msg-id 14827.1187231501@sss.pgh.pa.us
Whole thread Raw
In response to please! SPI_finish is strange  ("서기석"<akbar@korea.com>)
List pgsql-general
Tree view 
"=?EUC-KR?B?vK2x4ryu?="<akbar@korea.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

pgsql-general by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Re: SELECT ... FOR UPDATE performance costs? alternatives?
Next
From: Steve Manes
Date:
Subject: Re: Writing most code in Stored Procedures