Skip site navigation (1) Skip section navigation (2)

Re: indexes on functions and create or replace function

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Matthew Dennis <mdennis(at)merfer(dot)net>
Cc: Christophe <xof(at)thebuild(dot)com>, PGSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: indexes on functions and create or replace function
Date: 2008-08-29 02:41:20
Message-ID: 20080829024120.GM8424@alvh.no-ip.org (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-general by date

Next:From: Greg SmithDate: 2008-08-29 04:16:20
Subject: Re: WAL archiving to network drive
Previous:From: Matthew DennisDate: 2008-08-29 02:37:29
Subject: Re: indexes on functions and create or replace function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group