Re: PL/pgSQL bug?

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PL/pgSQL bug?
Date: 2001-09-30 16:18:08
Message-ID: 200109301618.f8UGI8A10476@saturn.jw.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 for now, 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(at)Yahoo(dot)com #

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ken Hirsch 2001-09-30 16:45:57 Re: Pre-forking backend
Previous Message Peter Eisentraut 2001-09-30 16:03:33 Re: CVS changes