Re: indexes on functions and create or replace function

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: indexes on functions and create or replace function
Дата
Msg-id 20080829024120.GM8424@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: indexes on functions and create or replace function  ("Matthew Dennis" <mdennis@merfer.net>)
Список pgsql-general
Matthew Dennis wrote:

> The cases about taking a string and sending it via execute don't seem to fit
> here for 1) cases where it is impossible to track the dependencies can be
> trivially constructed and 2) the very nature of the execute statement makes
> it obvious that it I shouldn't expect it to be tracked.  Poor Analogy: In C,
> if foo calls bar and I remove bar I expect the compiler to tell me.  If
> elsewhere in my code, I construct a memory address of where I believe bar
> should be and execute it I have no expectations for the compiler to tell me
> bar was removed.

The analogy is poor, yes.  A better analogy is the use of dlopen() on a
library.  If the library is not present at run time, the compiler will
not tell you anything.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: "Matthew Dennis"
Дата:
Сообщение: Re: indexes on functions and create or replace function
Следующее
От: Greg Smith
Дата:
Сообщение: Re: WAL archiving to network drive