Re: Reparse PL/pgSQL Function?

Поиск
Список
Период
Сортировка
От John Sidney-Woollett
Тема Re: Reparse PL/pgSQL Function?
Дата
Msg-id 1199.192.168.0.14.1073508920.squirrel@mercury.wardbrook.com
обсуждение исходный текст
Ответ на Re: Reparse PL/pgSQL Function?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: Re: VACUUM VERBOSE ANALYZE does not work on 7.4.1
Следующее
От: Dan Mahoney
Дата:
Сообщение: Problem with rserv replication