Re: SQL Functions and plan time - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL Functions and plan time
Date
Msg-id 22822.1057643615@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL Functions and plan time  (nolan@celery.tssi.com)
List pgsql-general
nolan@celery.tssi.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

pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: SQL Functions and plan time
Next
From: "adivi"
Date:
Subject: Fw: application compatibility with Oracle