Re: indexes on functions and create or replace function

Поиск
Список
Период
Сортировка
От Matthew Dennis
Тема Re: indexes on functions and create or replace function
Дата
Msg-id e94d85500808281810g1a09614ck4ecdae10b5fc8447@mail.gmail.com
обсуждение исходный текст
Ответ на Re: indexes on functions and create or replace function  (Christophe <xof@thebuild.com>)
Ответы Re: indexes on functions and create or replace function  (Christophe <xof@thebuild.com>)
Список pgsql-general
On Thu, Aug 28, 2008 at 7:52 PM, Christophe <xof@thebuild.com> wrote:

On Aug 28, 2008, at 5:49 PM, Matthew Dennis wrote:
Yes, I can see that would indeed be a problem.  Are there future plans to start tracking such dependencies?  It seems like it would be a good idea in general.

I believe the EXECUTE statement would thwart such plans.

I'm not sure I follow.  Couldn't you track which statements were prepared that called a function and either reprepare (just like reindex, recheck, etc) or in the case of dropping a function, refuse to drop it because something depends on it?  Until today, I was under the impression that PG did track such dependencies (because of the errors I get when trying to drop functions/views/tables when other things depend on it).  It seems to me that functions, prepared statements, checks and indexes are no different.  If they depend on something, PG should track the depenency.

В списке pgsql-general по дате отправления:

Предыдущее
От: Christophe
Дата:
Сообщение: Re: indexes on functions and create or replace function
Следующее
От: Christophe
Дата:
Сообщение: Re: indexes on functions and create or replace function