Re: PL/pgSQL bug? - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: PL/pgSQL bug?
Date
Msg-id 200109301618.f8UGI8A10476@saturn.jw.home
Whole thread Raw
In response to PL/pgSQL bug?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Tatsuo Ishii wrote:
> In the attached script, second call to test1() causes error:
   Well known error.
   PL/pgSQL  creates  saved  execution  plans  for  almost every   expression and query using SPI_prepare(),
SPI_saveplan(). If   any  of  the  objects,  referenced  from  such  a  plan get's   dropped, they become invalid and
fornow,  only  reconnecting   to the database can heal.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: CVS changes
Next
From: Jan Wieck
Date:
Subject: Re: Pre-forking backend