Re: Reparse PL/pgSQL Function? - Mailing list pgsql-general

From Rich Hall
Subject Re: Reparse PL/pgSQL Function?
Date
Msg-id 3FFC5C32.5050909@micropat.com
Whole thread Raw
In response to Re: Reparse PL/pgSQL Function?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
My take on the originmal question:
"If function Foo calls functioin Bar and you chanage Bar "sufficiently",
change the prameter list, return type.  etc.,  what would be necessary
to recompile Foo?"

Rick

scott.marlowe wrote:

>On Wed, 7 Jan 2004, John Sidney-Woollett wrote:
>
>
>>Is it possible to (automatically) force the reparse of a stored PL/pgSQL
>>function following the deletion and recreation of an object that was
>>referenced within the function (for example a table or another function)?
>>
>>
>
>Would
>
>CREATE OR REPLACE function
>
>work?
>



pgsql-general by date:

Previous
From: Együd Csaba
Date:
Subject: Re: Query performance question on a large table
Next
From: Tom Lane
Date:
Subject: Re: Query performance question on a large table