Re: ExecOpenScanR: failed to open relation

Tom Lane wrote:
> Pam Withnall <Pamw(at)zoom(dot)com(dot)au> writes:
> > in my java code I am creating 3 temporary tables, then calling a stored
> > procedure which calls another stored procedure.
> > then I drop the temporary tables.
> > the first time around , eveything is OK , then when repeating the action I
> > get
> > "ExecOpenScanR: failed to open relation 2808495 "
>
> If you're using plpgsql, you can't drop and recreate temp tables between
> procedure executions, because the cached query plans for the procedure
> will still refer to the old version of the tables.
>
> Either create the temp table *once* per backend, or use pltcl, which
> doesn't try to cache query plans.

as long as you don't tell it to (using spi_prepare and
spi_execp explicitly in PL/Tcl) :-)

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