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

From John Sidney-Woollett
Subject Re: Reparse PL/pgSQL Function?
Date
Msg-id 1199.192.168.0.14.1073508920.squirrel@mercury.wardbrook.com
Whole thread Raw
In response to Re: Reparse PL/pgSQL Function?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
It would, but you have to locate all the functions that referenced your
deleted and recreated table... That's the pain.

If you miss one, you find out later when your app dies with an unexpected
error thrown by postgres.

John

scott.marlowe said:
> 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: Joseph Shraibman
Date:
Subject: Re: VACUUM VERBOSE ANALYZE does not work on 7.4.1
Next
From: Dan Mahoney
Date:
Subject: Problem with rserv replication