Re: SQL Functions and plan time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nolan(at)celery(dot)tssi(dot)com
Cc: dev(at)archonet(dot)com (Richard Huxton), pgsql-general(at)postgresql(dot)org
Subject: Re: SQL Functions and plan time
Date: 2003-07-08 05:53:35
Message-ID: 22822.1057643615@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

nolan(at)celery(dot)tssi(dot)com writes:
> Several weeks ago I posted a note about a plpgsql function that fails
> if an index that existed when it was created is subsequently dropped.

No surprise...

> Would a cross-query plan cache for SQL functions create similar problems?

Yeah. We need to think about a mechanism for invalidating plans before
we go too much further down the road of caching plans.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message adivi 2003-07-08 05:58:26 Fw: application compatibility with Oracle
Previous Message nolan 2003-07-08 05:49:27 Re: SQL Functions and plan time