Re: Plan invalidation vs temp sequences - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Plan invalidation vs temp sequences
Date
Msg-id 87myuq83jm.fsf@oxford.xeocode.com
Whole thread Raw
In response to Plan invalidation vs temp sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Plan invalidation vs temp sequences
Re: Plan invalidation vs temp sequences
List pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> There doesn't seem to be any very nice way to fix this.  There is
> not any existing support mechanism (comparable to query_tree_walker)
> for scanning whole plan trees, which means that searching a cached plan
> for regclass Consts is going to involve a chunk of new code no matter
> how we approach it.  We might want to do that someday --- in particular,
> if we ever try to extend the plan inval mechanism to react to
> redefinitions of non-table objects, we'd likely need some such thing
> anyway.  I'm disinclined to try to do it for 8.3 though.  The use-case
> for temp sequences seems a bit narrow and there are several workarounds
> (see followups to bug report), so I'm feeling this is a
> fix-some-other-day kind of issue.

Given that sequences are in fact relations is there some way to work around
the issue at least in this case by stuffing the sequence's relid someplace
which the plan invalldation code can check for it?


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: "Brendan Jurd"
Date:
Subject: Re: quote_literal with NULL
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: Including Snapshot Info with Indexes