Re: view/pgpgsql functions bug - Mailing list pgsql-general

From Tom Lane
Subject Re: view/pgpgsql functions bug
Date
Msg-id 23661.1109204355@sss.pgh.pa.us
Whole thread Raw
In response to view/pgpgsql functions bug  (Joe Maldonado <jmaldonado@webehosting.biz>)
Responses Re: view/pgpgsql functions bug  (Joe Maldonado <jmaldonado@webehosting.biz>)
List pgsql-general
Joe Maldonado <jmaldonado@webehosting.biz> writes:
> After a create or replace view, the new view definition is not being
> used by plpgsql functions that use the view. Is this a known bug ? Is
> there a workaround it ?

Start a fresh backend session.  The old query plan is presumably being
cached by plpgsql.  (Yes, this is something we'd like to fix.)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: stats collector appears to be dying
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.