Re: Reparse PL/pgSQL Function?

From: Rich Hall <rhall(at)micropat(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Reparse PL/pgSQL Function?
Date: 2004-01-07 19:21:22
Message-ID: 3FFC5C32.5050909@micropat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-07 19:35:37 Re: Query performance question on a large table
Previous Message Együd Csaba 2004-01-07 19:16:55 Re: Query performance question on a large table