Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Ken HirschDate: 2001-09-30 16:45:57
Subject: Re: Pre-forking backend
Previous:From: Peter EisentrautDate: 2001-09-30 16:03:33
Subject: Re: CVS changes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group