[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] PL/pgSQL bug?
From:       Jan Wieck <JanWieck () yahoo ! com>
Date:       2001-09-30 16:18:08
[Download RAW message or body]

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@Yahoo.com #



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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

[prev in list] [next in list] [prev in thread] [next in thread]