| 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: | Whole Thread | Raw Message | 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
| 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 |