Re: Backport "WITH ... AS MATERIALIZED" syntax to <12? - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?
Date
Msg-id 20191019023403.GD1542@paquier.xyz
Whole thread Raw
In response to Backport "WITH ... AS MATERIALIZED" syntax to <12?  (Colin Watson <cjwatson@canonical.com>)
Responses Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?
List pgsql-hackers
On Fri, Oct 18, 2019 at 02:21:30PM +0100, Colin Watson wrote:
> However, an alternative would be to backport the new syntax to some
> earlier versions.  "WITH ... AS MATERIALIZED" can easily just be
> synonymous with "WITH ... AS" in versions prior to 12; there's no need
> to support "NOT MATERIALIZED" since that's explicitly requesting the new
> query-folding feature that only exists in 12.  Would something like the
> attached patch against REL_11_STABLE be acceptable?  I'd like to
> backpatch it at least as far as PostgreSQL 10.

I am afraid that new features don't gain a backpatch.  This is a
project policy.  Back-branches should just include bug fixes.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: recovery_min_apply_delay in archive recovery causes assertionfailure in latch
Next
From: Michael Paquier
Date:
Subject: Re: v12.0: reindex CONCURRENTLY: lock ShareUpdateExclusiveLock onobject 14185/39327/0 is already held