Re: read-only planner input

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: read-only planner input
Date: 2005-03-18 23:15:12
Message-ID: 423B6100.8030105@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> It is well defined, because we insist that the gram.y transformation not
> depend on any changeable state.

That's my point -- whether we begin from the query string or the raw
parsetree shouldn't make a difference. By not well-defined, I meant that
if the user is changing GUC variables on the fly, they can't rely on
their prepared query being planned under any particular datestyle (or
search path, etc.), since they can't really predict when replanning will
take place (e.g. an sinval overflow could occur spontaneously and cause
all cached plans to be invalidated). This is similar to how search_path
and pl/pgsql works right now -- we'll use the search_path in effect when
the query is planned, which may or may not be what the user would expect.

-Neil

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Eric Parusel 2005-03-19 02:16:45 Re: corrupted tuple (header?), pg_filedump output
Previous Message Mark Kirkwood 2005-03-18 22:35:40 Re: GUC variable for setting number of local buffers