Opened 5 years ago

Closed 5 years ago

#4352 closed enhancement (fixed)

Use CREATE OR REPLACE for aggregates when possible

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 3.0.0
Component: build Version: master
Keywords: Cc:

Description

Thanks to Andrew Gierth (RhodiumToad on IRC) PostgreSQL 12 will have CREATE OR REPLACE AGGREGATE. We could start using it from the upgrade script:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=01bde4fa4c24f4eea0a634d8fcad0b376efda6b1

Change History (5)

comment:1 by strk, 5 years ago

Example of the problem we'll be able to fix with PostgreSQL 12 if we implement this: #4386

comment:2 by strk, 5 years ago

Another example we'd be able to fix: #4334

comment:4 by Raul Marin, 5 years ago

In 17488:

Use CREATE OR REPLACE AGGREGATE for PG12+

References #4352

comment:5 by Raul Marin, 5 years ago

Resolution: fixed
Status: newclosed

In 17489:

Perl tidy over postgis_proc_upgrade.pl

To match PostgreSQL convenctions I've used
perltidy -b -bl -nsfs -naws -l=100 -ole=unix postgis_proc_upgrade.pl

Closes #4352

Note: See TracTickets for help on using tickets.