Re: plpgsql function confusing behaviour

From: Shianmiin <Shianmiin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql function confusing behaviour
Date: 2011-07-12 17:10:50
Message-ID: 1310490650891-4579619.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Merlin Moncure-2 wrote:
>
> One proposed solution is to cache plpgsql plans around the search path.
>

I like the proposed solution, since search_path plays a part when generating
plpgsql plan, it make sense to be part of the cache.

Merlin Moncure-2 wrote:
>
> *) use sql functions for portions that float across schemas
>

Just to clarify, does this mean the sql functions doesn't cache plans like
plpgsql functions do?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/plpgsql-function-confusing-behaviour-tp4576354p4579619.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wim Bertels 2011-07-12 18:03:47 psql feature request
Previous Message Alban Hertroys 2011-07-12 17:06:10 Re: Unexpected results when joining on date fields