Re: indexes on functions and create or replace function - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: indexes on functions and create or replace function
Date
Msg-id 20080829024120.GM8424@alvh.no-ip.org
Whole thread Raw
In response to Re: indexes on functions and create or replace function  ("Matthew Dennis" <mdennis@merfer.net>)
List 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 by date:

Previous
From: "Matthew Dennis"
Date:
Subject: Re: indexes on functions and create or replace function
Next
From: Greg Smith
Date:
Subject: Re: WAL archiving to network drive