BUG #15344: pg_proc.proisagg was removed incompatibly in PostgreSQL 11 - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15344: pg_proc.proisagg was removed incompatibly in PostgreSQL 11
Date
Msg-id 153486142520.1370.12035528830969343708@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15344: pg_proc.proisagg was removed incompatibly inPostgreSQL 11
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15344
Logged by:          Lukas Eder
Email address:      lukas.eder@gmail.com
PostgreSQL version: 11beta2
Operating system:   Debian
Description:

When comparing the current version (10) [1] and the developer version (11)
[2] of the pg_proc documentation, then it can be seen that the
pg_proc.proisagg column was removed backwards incompatibly. The
documentation states for [1]:

> The table contains data for aggregate functions as well as plain
functions. If proisagg is true, there should be a matching row in
pg_aggregate.

And for [2]:

> If prokind indicates that the entry is for an aggregate function, there
should be a matching row in pg_aggregate.

While I appreciate that an encoded enumeration is more powerful than a
simple boolean value, I think it would have been better if this change had
been done backwards compatibly. For example, there could still be a
pg_proc.proisagg column that defaults to (prokind = 'a').

[1] https://www.postgresql.org/docs/10/static/catalog-pg-proc.html
[2] https://www.postgresql.org/docs/11/static/catalog-pg-proc.html


pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #15343: Segmentation fault using pg_dump with --exclude-tableif table contains identity column
Next
From: Andres Freund
Date:
Subject: Re: BUG #15344: pg_proc.proisagg was removed incompatibly inPostgreSQL 11