PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16255
PG Version12.1
OSWindows
Opened2020-02-12 12:28:25+00
Reported byRobert Ford
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16255
Logged by:          Robert Ford
Email address:      (redacted)
PostgreSQL version: 12.1
Operating system:   Windows
Description:        

I have an simple CTE expression with group by and a string_aggr() function,
and Postgresql seems to materialize it anyhow, even if 'not materialized' is
instructed. I can't see that this is documented behaviour.

Messages

DateAuthorSubject
2020-02-12 12:28:25+00PG Bug reporting formBUG #16255: No respect for 'not materialized' on CTEs with group by
2020-02-12 15:11:37+00Tom LaneRe: BUG #16255: No respect for 'not materialized' on CTEs with group by