Re: view/pgpgsql functions bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: view/pgpgsql functions bug
Date: 2005-02-24 00:19:15
Message-ID: 23661.1109204355@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Maldonado <jmaldonado(at)webehosting(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-02-24 00:31:05 Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.
Previous Message Tom Lane 2005-02-24 00:05:57 Re: stats collector appears to be dying