| From: | "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Reparse PL/pgSQL Function? |
| Date: | 2004-01-07 20:55:20 |
| Message-ID: | 1199.192.168.0.14.1073508920.squirrel@mercury.wardbrook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Mahoney | 2004-01-07 21:28:59 | Problem with rserv replication |
| Previous Message | Joseph Shraibman | 2004-01-07 20:48:30 | pg_stats question |