[pkgsrc/trunk]: pkgsrc/databases postgresql: updated to 12.4, 11.9, 10.14, 9....

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/402c121647e6
branches:  trunk
changeset: 436998:402c121647e6
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Aug 14 06:56:22 2020 +0000

description:
postgresql: updated to 12.4, 11.9, 10.14, 9.6.19, 9.5.23

PostgreSQL 12.4, 11.9, 10.14, 9.6.19, 9.5.23

Security Issues

CVE-2020-14349: Uncontrolled search path element in logical replication.
Versions Affected: 10 - 12.

The PostgreSQL search_path setting determines schemas searched for tables, functions, operators, etc. The CVE-2018-1058 fix caused most PostgreSQL-provided client applications to sanitize 
search_path, but logical replication continued to leave search_path unchanged. Users of a replication publisher or subscriber database can create objects in the public schema and harness them to 
execute arbitrary SQL functions under the identity running replication, often a superuser. Installations having adopted a documented secure schema usage pattern are not vulnerable.

The PostgreSQL project thanks Noah Misch for reporting this problem.

CVE-2020-14350: Uncontrolled search path element in CREATE EXTENSION.
Versions Affected: 9.5 - 12. The security team typically does not test unsupported versions, but this problem is quite old.

When a superuser runs certain CREATE EXTENSION statements, users may be able to execute arbitrary SQL functions under the identity of that superuser. The attacker must have permission to create 
objects in the new extension's schema or a schema of a prerequisite extension. Not all extensions are vulnerable.

In addition to correcting the extensions provided with PostgreSQL, the PostgreSQL Global Development Group is issuing guidance for third-party extension authors to secure their own work.

Bug Fixes and Improvements

This update also fixes over 50 bugs that were reported in the last several months. Some of these issues affect only version 12, but many affect all supported versions.

Some of these fixes include:

Fix edge cases in partition pruning involving multiple partition key columns with multiple or no constraining WHERE clauses.
Several fixes for query planning and execution involving partitions.
Fix for determining when to execute a column-specific UPDATE trigger on a logical replication subscriber.
pg_replication_slot_advance() now updates the oldest xmin and LSN values, as the failure to do this could prevent resources (e.g. WAL files) from being cleaned up.
Fix a performance regression in ts_headline().
Ensure that pg_read_file() and related functions read until EOF is reached, which fixes compatibility with pipes and other virtual files.
Forbid numeric NaN values in jsonpath computations, which do not exist in SQL nor JSON.
Several fixes for NaN inputs with aggregate functions. This fixes a change in PostgreSQL 12 where NaN values caused the following aggregates to emit values of 0 instead of NaN: corr(), covar_pop(), 
regr_intercept(), regr_r2(), regr_slope(), regr_sxx(), regr_sxy(), regr_syy(), stddev_pop(), and var_pop().
time and timetz values fractionally greater than 24:00:00 are now rejected.
Several fixes for EXPLAIN, including a fix for reporting resource usage when a plan uses parallel workers with "Gather Merge" nodes.
Fix timing of constraint revalidation in ALTER TABLE that could lead to odd errors.
Fix for REINDEX CONCURRENTLY that could prevent old values from being included in future logical decoding output.
Fix for LATERAL references that could potentially cause crashes during query execution.
Use the collation specified for a query when estimating operator costs
Fix conflict-checking anomalies in SERIALIZABLE transaction isolation mode.
Ensure checkpointer process discards file sync requests when fsync is off
Fix issue where pg_control could be written out with an inconsistent checksum, which could lead to the inability to restart the database if it crashed before the next pg_control update.
Ensure that libpq continues to try to read from the database connection socket after a write failure, as this allows the connection to collect any final error messages from the server.
Report out-of-disk-space errors properly in pg_dump and pg_basebackup
Several fixes for pg_restore, including a fix for parallel restore on tables that have both table-level and column-level privileges.
Fix for pg_upgrade to ensure it runs with vacuum_defer_cleanup_age set to 0.
Fix how pg_rewind handles just-deleted files in the source data directory
Fix failure to initialize local state correctly in contrib/dblink, which could lead to dblink_close() issuing an unexpected COMMIT on the remote server.
Change contrib/amcheck to not report about deleted index pages that are empty, as this is normal during WAL replay.

diffstat:

 databases/postgresql10-client/Makefile   |   3 +--
 databases/postgresql10-client/PLIST      |   3 ++-
 databases/postgresql10-contrib/Makefile  |   3 +--
 databases/postgresql10-docs/Makefile     |   3 +--
 databases/postgresql10-docs/PLIST        |   4 +++-
 databases/postgresql10-plperl/Makefile   |   3 +--
 databases/postgresql10-plpython/Makefile |   3 +--
 databases/postgresql10-pltcl/Makefile    |   3 +--
 databases/postgresql10-server/Makefile   |   3 +--
 databases/postgresql10/Makefile          |   3 +--
 databases/postgresql10/Makefile.common   |   4 ++--
 databases/postgresql10/distinfo          |  10 +++++-----
 databases/postgresql11-client/Makefile   |   3 +--
 databases/postgresql11-client/PLIST      |   3 ++-
 databases/postgresql11-contrib/Makefile  |   3 +--
 databases/postgresql11-docs/Makefile     |   3 +--
 databases/postgresql11-docs/PLIST        |   4 +++-
 databases/postgresql11-plperl/Makefile   |   3 +--
 databases/postgresql11-plpython/Makefile |   3 +--
 databases/postgresql11-pltcl/Makefile    |   3 +--
 databases/postgresql11-server/Makefile   |   3 +--
 databases/postgresql11/Makefile          |   3 +--
 databases/postgresql11/Makefile.common   |   4 ++--
 databases/postgresql11/distinfo          |  10 +++++-----
 databases/postgresql12-client/Makefile   |   3 +--
 databases/postgresql12-client/PLIST      |   4 +++-
 databases/postgresql12-contrib/Makefile  |   3 +--
 databases/postgresql12-docs/Makefile     |   3 +--
 databases/postgresql12-docs/PLIST        |   4 +++-
 databases/postgresql12-plperl/Makefile   |   3 +--
 databases/postgresql12-plpython/Makefile |   3 +--
 databases/postgresql12-pltcl/Makefile    |   3 +--
 databases/postgresql12-server/Makefile   |   3 +--
 databases/postgresql12-server/PLIST      |   3 ++-
 databases/postgresql12/Makefile          |   3 +--
 databases/postgresql12/Makefile.common   |   4 ++--
 databases/postgresql12/distinfo          |  10 +++++-----
 databases/postgresql95-client/Makefile   |   3 +--
 databases/postgresql95-contrib/Makefile  |   3 +--
 databases/postgresql95-docs/Makefile     |   3 +--
 databases/postgresql95-docs/PLIST        |   4 +++-
 databases/postgresql95-plperl/Makefile   |   3 +--
 databases/postgresql95-plpython/Makefile |   3 +--
 databases/postgresql95-pltcl/Makefile    |   3 +--
 databases/postgresql95-server/Makefile   |   3 +--
 databases/postgresql95/Makefile          |   3 +--
 databases/postgresql95/Makefile.common   |   4 ++--
 databases/postgresql95/distinfo          |  10 +++++-----
 databases/postgresql96-client/Makefile   |   3 +--
 databases/postgresql96-contrib/Makefile  |   3 +--
 databases/postgresql96-docs/Makefile     |   3 +--
 databases/postgresql96-docs/PLIST        |   4 +++-
 databases/postgresql96-plperl/Makefile   |   3 +--
 databases/postgresql96-plpython/Makefile |   3 +--
 databases/postgresql96-pltcl/Makefile    |   3 +--
 databases/postgresql96-server/Makefile   |   3 +--
 databases/postgresql96/Makefile          |   3 +--
 databases/postgresql96/Makefile.common   |   4 ++--
 databases/postgresql96/distinfo          |  10 +++++-----
 59 files changed, 99 insertions(+), 124 deletions(-)

diffs (truncated from 861 to 300 lines):

diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-client/Makefile
--- a/databases/postgresql10-client/Makefile    Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-client/Makefile    Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql10/Makefile.common"
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-client/PLIST
--- a/databases/postgresql10-client/PLIST       Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-client/PLIST       Fri Aug 14 06:56:22 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2019/10/25 12:01:19 triaxx Exp $
+@comment $NetBSD: PLIST,v 1.9 2020/08/14 06:56:22 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -251,6 +251,7 @@
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/base64.h
 include/postgresql/server/common/config_info.h
+include/postgresql/server/common/connect.h
 include/postgresql/server/common/controldata_utils.h
 include/postgresql/server/common/fe_memutils.h
 include/postgresql/server/common/file_utils.h
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-contrib/Makefile
--- a/databases/postgresql10-contrib/Makefile   Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-contrib/Makefile   Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql10/Makefile.common"
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-docs/Makefile
--- a/databases/postgresql10-docs/Makefile      Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-docs/Makefile      Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql10/Makefile.common"
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-docs/PLIST
--- a/databases/postgresql10-docs/PLIST Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-docs/PLIST Fri Aug 14 06:56:22 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.14 2020/05/15 09:45:00 adam Exp $
+@comment $NetBSD: PLIST,v 1.15 2020/08/14 06:56:22 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -458,6 +458,7 @@
 share/doc/postgresql/html/datetime-input-rules.html
 share/doc/postgresql/html/datetime-invalid-input.html
 share/doc/postgresql/html/datetime-keywords.html
+share/doc/postgresql/html/datetime-posix-timezone-specs.html
 share/doc/postgresql/html/datetime-units-history.html
 share/doc/postgresql/html/dblink.html
 share/doc/postgresql/html/ddl-alter.html
@@ -913,6 +914,7 @@
 share/doc/postgresql/html/release-10-11.html
 share/doc/postgresql/html/release-10-12.html
 share/doc/postgresql/html/release-10-13.html
+share/doc/postgresql/html/release-10-14.html
 share/doc/postgresql/html/release-10-2.html
 share/doc/postgresql/html/release-10-3.html
 share/doc/postgresql/html/release-10-4.html
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-plperl/Makefile
--- a/databases/postgresql10-plperl/Makefile    Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-plperl/Makefile    Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.6 2020/06/02 08:23:27 adam Exp $
+#$ $NetBSD: Makefile,v 1.7 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-plpython/Makefile
--- a/databases/postgresql10-plpython/Makefile  Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-plpython/Makefile  Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-pltcl/Makefile
--- a/databases/postgresql10-pltcl/Makefile     Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-pltcl/Makefile     Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.8 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10-server/Makefile
--- a/databases/postgresql10-server/Makefile    Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10-server/Makefile    Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.12 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10/Makefile
--- a/databases/postgresql10/Makefile   Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10/Makefile   Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2020/06/02 08:23:26 adam Exp $
+# $NetBSD: Makefile,v 1.18 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql10-client>=${PKGVERSION_NOREV}:../../databases/postgresql10-client
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10/Makefile.common
--- a/databases/postgresql10/Makefile.common    Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10/Makefile.common    Fri Aug 14 06:56:22 2020 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.21 2020/08/07 19:39:39 maya Exp $
+# $NetBSD: Makefile.common,v 1.22 2020/08/14 06:56:22 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql10-pltcl/Makefile
 # used by databases/postgresql10-server/Makefile
 
-DISTNAME=      postgresql-10.13
+DISTNAME=      postgresql-10.14
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql10/distinfo
--- a/databases/postgresql10/distinfo   Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql10/distinfo   Fri Aug 14 06:56:22 2020 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.15 2020/05/15 09:45:00 adam Exp $
+$NetBSD: distinfo,v 1.16 2020/08/14 06:56:22 adam Exp $
 
-SHA1 (postgresql-10.13.tar.bz2) = adb3d5a27abedcc712c9a3687c42631083c5ba0d
-RMD160 (postgresql-10.13.tar.bz2) = dfbe651ec0456cd567eecff9bb49e0da9dcddec9
-SHA512 (postgresql-10.13.tar.bz2) = 7b268aa4476ed9b168814891e8b19d182683ab4994d4a9b30e75eec93ffd9c860f8a0979ba1b7408acf8e217437b5cc20037b6ebf6ef01e9cf5ee99f091c8c92
-Size (postgresql-10.13.tar.bz2) = 19028339 bytes
+SHA1 (postgresql-10.14.tar.bz2) = db230e62422673814419e76508708164a2cbfb09
+RMD160 (postgresql-10.14.tar.bz2) = 7f73551d98a67bbfd285be9185e529a43755da50
+SHA512 (postgresql-10.14.tar.bz2) = eecd2aa8df7e4779606ec547b7bf0207ebb2be10a4b332f06c3b72116f0619fe27fb651f2fd4504c73b740ab7f92468919244a615d460bb9c35085174a0dbc78
+Size (postgresql-10.14.tar.bz2) = 19042154 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-client/Makefile
--- a/databases/postgresql11-client/Makefile    Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-client/Makefile    Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql11/Makefile.common"
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-client/PLIST
--- a/databases/postgresql11-client/PLIST       Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-client/PLIST       Fri Aug 14 06:56:22 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2019/11/19 18:42:41 schmonz Exp $
+@comment $NetBSD: PLIST,v 1.7 2020/08/14 06:56:23 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -309,6 +309,7 @@
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/base64.h
 include/postgresql/server/common/config_info.h
+include/postgresql/server/common/connect.h
 include/postgresql/server/common/controldata_utils.h
 include/postgresql/server/common/fe_memutils.h
 include/postgresql/server/common/file_perm.h
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-contrib/Makefile
--- a/databases/postgresql11-contrib/Makefile   Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-contrib/Makefile   Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.7 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql11/Makefile.common"
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-docs/Makefile
--- a/databases/postgresql11-docs/Makefile      Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-docs/Makefile      Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.4 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql11/Makefile.common"
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-docs/PLIST
--- a/databases/postgresql11-docs/PLIST Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-docs/PLIST Fri Aug 14 06:56:22 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2020/05/15 09:45:00 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2020/08/14 06:56:23 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -483,6 +483,7 @@
 share/doc/postgresql/html/datetime-input-rules.html
 share/doc/postgresql/html/datetime-invalid-input.html
 share/doc/postgresql/html/datetime-keywords.html
+share/doc/postgresql/html/datetime-posix-timezone-specs.html
 share/doc/postgresql/html/datetime-units-history.html
 share/doc/postgresql/html/dblink.html
 share/doc/postgresql/html/ddl-alter.html
@@ -952,6 +953,7 @@
 share/doc/postgresql/html/release-11-6.html
 share/doc/postgresql/html/release-11-7.html
 share/doc/postgresql/html/release-11-8.html
+share/doc/postgresql/html/release-11-9.html
 share/doc/postgresql/html/release-11.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-plperl/Makefile
--- a/databases/postgresql11-plperl/Makefile    Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-plperl/Makefile    Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.4 2020/06/02 08:23:28 adam Exp $
+#$ $NetBSD: Makefile,v 1.5 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-plpython/Makefile
--- a/databases/postgresql11-plpython/Makefile  Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-plpython/Makefile  Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.8 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-pltcl/Makefile
--- a/databases/postgresql11-pltcl/Makefile     Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-pltcl/Makefile     Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server
diff -r 913bc05c6190 -r 402c121647e6 databases/postgresql11-server/Makefile
--- a/databases/postgresql11-server/Makefile    Fri Aug 14 06:08:11 2020 +0000
+++ b/databases/postgresql11-server/Makefile    Fri Aug 14 06:56:22 2020 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.9 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation