== PostgreSQL Weekly News - October 28, 2018 ==

== PostgreSQL Weekly News - October 28, 2018 ==

PGDay Argentina 2018 will be held in Buenos Aires on November 21, 2018. The CfP
is open through October 31, 2018.
http://www.pgday.com.ar/buenosaires2018/?lang=en

== PostgreSQL Product News ==

Pgpool-II 4.0.0 and pgpoolAdmin 4.0.0 released.
http://www.pgpool.net/docs/latest/en/html/release-4-0.html

barman 2.5, a backup and recovery manager for PostgreSQL, released.
https://www.pgbarman.org/barman-2-5-released/

pg_permission 1.0, an extension which uses table data to set norms for access
controls and includes tools to check them against the system's actual access
controls, released.
https://github.com/cybertec-postgresql/pg_permission

Benetl 4.9, an ETL tool for postgreSQL, released.
http://www.benetl.net

PipelineDB v1.0.0, an extension to handle streaming time-series data, released.
https://www.pipelinedb.com/blog/pipelinedb-1-0-0-high-performance-time-series-aggregation-for-postgresql

== PostgreSQL Jobs for October ==

http://archives.postgresql.org/pgsql-jobs/2018-10/

== PostgreSQL Local ==

pgday.Seoul 2018 will be held in Seoul, South Korea on November 3, 2018 in
Seoul. Korean language information is here:
http://pgday.postgresql.kr/

2Q PGConf will be on December 4-5, 2018 in Chicago, IL.
http://www.2qpgconf.com/

PGConf.ASIA 2018 will take place on December 10-12, 2018 in Akihabara, Tokyo,
Japan.
http://www.pgconf.asia/EN/2018/

pgDay Paris 2019 will be held in Paris, France on March 12, 2019
at 199bis rue Saint-Martin. The CfP is open until November 30, 2018.
http://2019.pgday.paris/callforpapers/

PGConf APAC 2019 will be held in Singapore March 19-21, 2019. The CfP is open
at http://2019.pgconfapac.org/cfp through November 16, 2018.
http://2019.pgconfapac.org/

PGDay.IT 2019 will take place May 16th and May 17th in Bologna, Italy. The CfP
is open at https://2019.pgday.it/en/blog/cfp and the Call for Workshops is at
https://2019.pgday.it/en/blog/cfw until January 15, 2019.
https://2019.pgday.it/en/

== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

PostgreSQL Weekly News is brought to you this week by David Fetter

Submit news and announcements by Sunday at 3:00pm PST8PDT to david(at)fetter(dot)org(dot)

== Applied Patches ==

Alexander Korotkov pushed:

- Fix some grammar errors in bloom.sgml. Discussion:
https://postgr.es/m/CAEepm%3D3sijpGr8tXdyz-7EJJZfhQHABPKEQ29gpnb7-XSy%2B%3D5A%40mail.gmail.com
Reported-by: Thomas Munro Backpatch-through: 9.6
https://git.postgresql.org/pg/commitdiff/31ff51adc855e3ffe8e3c20e479b8d1a4508feb8

Michaël Paquier pushed:

- Clarify descriptions of relhassubclass and relispartition in pg_class. Three
places are fixed, one for each author. Reported-by: Tom Lane Author: Tom
Lane, Amit Langote, Michael Paquier Discussion:
https://postgr.es/m/82470.1540177167@sss.pgh.pa.us
https://git.postgresql.org/pg/commitdiff/55853d666ce5d0024c50dc3d223346df28abfa70

- Set pg_class.relhassubclass for partitioned indexes. Like for relations,
switching this parameter is optimistic by turning it on each time a
partitioned index gains a partition. So seeing this parameter set to true
means that the partitioned index has or has had partitions. The flag cannot
be reset yet for partitioned indexes, which is something not obvious anyway as
partitioned relations exist to have partitions. This allows to track more
conveniently partition trees for indexes, which will come in use with an
upcoming patch helping in listing partition trees with an SQL-callable
function. Author: Amit Langote Reviewed-by: Michael Paquier Discussion:
https://postgr.es/m/80306490-b5fc-ea34-4427-f29c52156052@lab.ntt.co.jp
https://git.postgresql.org/pg/commitdiff/17f206fbc824d2b4b14480199ca9ff7dea417eda

- List wait events in alphabetical order. This changes the documentation, and
the related structures so as everything is consistent. Some wait events were
not listed alphabetically since their introduction, others have been added
rather randomly. Keeping all those entries in order helps in maintenance, and
helps the user looking at the documentation. Author: Michael Paquier, Kuntal
Ghosh Discussion: https://postgr.es/m/20181024002539.GI1658@paquier.xyz
Backpatch-through: 10, only for the documentation part to avoid an ABI
breakage.
https://git.postgresql.org/pg/commitdiff/5ef037cf0b9e130120c5a788f1f1048f6242b076

- Add pg_promote function. This function is able to promote a standby with this
new SQL-callable function. Execution access can be granted to non-superusers
so that failover tools can observe the principle of least privilege. Catalog
version is bumped. Author: Laurenz Albe Reviewed-by: Michael Paquier,
Masahiko Sawada Discussion:
https://postgr.es/m/6e7c79b3ec916cf49742fb8849ed17cd87aed620.camel@cybertec.at
https://git.postgresql.org/pg/commitdiff/10074651e3355e2405015f6253602be8344bc829

- Add tab completion of EXECUTE FUNCTION for CREATE TRIGGER in psql. The change
to accept EXECUTE FUNCTION as well as EXECUTE PROCEDURE in CREATE TRIGGER
(added by 0a63f99) forgot to tell psql's tab completion system about this. In
passing, add tab completion of EXECUTE FUNCTION/PROCEDURE after a complete
WHEN ( … ) clause. This change is version-aware, with FUNCTION being selected
automatically instead of PROCEDURE depending on the backend version, PROCEDURE
being an historical grammar kept for compatibility and considered as
deprecated in v11. Author: Dagfinn Ilmari Mannsåker Reviewed-by: Tom Lane,
Michael Paquier Discussion:
https://postgr.es/m/d8jmur4q4yc.fsf@dalvik.ping.uio.no
https://git.postgresql.org/pg/commitdiff/292ef6e2778afb3ecea250fc50326587543ae144

- Improve tab completion of CREATE EVENT TRIGGER in psql. This adds tab
completion of the clauses WHEN and EXECUTE FUNCTION|PROCEDURE clauses to
CREATE EVENT TRIGGER, similar to CREATE TRIGGER in the previous commit. This
has version-dependent logic so as FUNCTION is chosen over PROCEDURE for 11 and
newer versions. Author: Dagfinn Ilmari Mannsåker Reviewed-by: Tom Lane,
Michael Paquier Discussion:
https://postgr.es/m/d8jmur4q4yc.fsf@dalvik.ping.uio.no
https://git.postgresql.org/pg/commitdiff/5953c99697621174f50aa219a3cd457212968268

Peter Eisentraut pushed:

- Sprinkle some const decorations. These mainly help understanding the function
signatures better.
https://git.postgresql.org/pg/commitdiff/807e4bc828cff0645d2a776604dc7cdc733b2fd3

- Drop const cast from dlsym() calls. This workaround might be obsolete. We'll
see if those "older platforms" mentioned in the comment are still around.
Discussion:
https://www.postgresql.org/message-id/08adbe4e-38f8-2c73-55f0-591392371687%402ndquadrant.com
https://git.postgresql.org/pg/commitdiff/e6f5d1accd3ae170a0baa632bfe3396bdd9b6e92

- Remove get_attidentity(). All existing uses can get this information more
easily from the relation descriptor, so the detour through the syscache is not
necessary. Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
https://git.postgresql.org/pg/commitdiff/5d7c703a44101f0d686fb66f4ff671429f46a84c

- Remove get_atttypmod(). This has been unused since 2004.
get_atttypetypmodcoll() is often a better alternative. Reviewed-by: Michael
Paquier <michael(at)paquier(dot)xyz>
https://git.postgresql.org/pg/commitdiff/c903bb7b1c3ce82e21d6bd1af1dc45a58cd88455

- Improve unconstify() documentation. Refer to expression instead of variable
when appropriate. Discussion:
https://www.postgresql.org/message-id/08adbe4e-38f8-2c73-55f0-591392371687%402ndquadrant.com
https://git.postgresql.org/pg/commitdiff/f2898de98a5407a8b78f49866ef4931813505ca2

- Apply unconstify() in more places. Discussion:
https://www.postgresql.org/message-id/08adbe4e-38f8-2c73-55f0-591392371687%402ndquadrant.com
https://git.postgresql.org/pg/commitdiff/0a8590b2a09e7a9e10612bc38d5e872b0c234eca

Andrew Dunstan pushed:

- Correctly set t_self for heap tuples in expand_tuple. Commit 16828d5c0
incorrectly set an invalid pointer for t_self for heap tuples. This patch
correctly copies it from the source tuple, and includes a regression test that
relies on it being set correctly. Backpatch to release 11. Fixes bug #15448
reported by Tillmann Schulz Diagnosis and test case by Amit Langote
https://git.postgresql.org/pg/commitdiff/040a1df6149f852c3b8de96d9d13258af8a39e23

- Fix typo in regression test comment. per Michael Banck
https://git.postgresql.org/pg/commitdiff/4beea5508e80a65a90f3fa857ea34ec71b9d6db2

- Fix perl searchpath for modern perl for MSVC tools. Modern versions of perl
no longer include the current directory in the perl searchpath, as it's
insecure. Instead of adding the current directory, we get around the problem
by adding the directory where the script lives. Problem noted by Victor
Wagner. Solution adapted from buildfarm client code. Backpatch to all live
versions.
https://git.postgresql.org/pg/commitdiff/1df92eeafefac471b8bcb00244452c645e4e14fd

== Pending Patches ==

Alexander Korotkov sent in another revision of a patch to remove some snapshot
functions from TableAmRoutine and add costing functions to the tableam
interface.

Oleg Bartunov sent in a patch to remove documentation for the @@@ operator.

John Naylor sent in another revision of a patch to avoid creation of the free
space map for small tables.

Haribabu Kommi sent in four more revisions of a patch to remove the old slot
interface file, add grammar support for CREATE AS ... USING, remove an extra
tuple visibility check, and add an API to create INIT_FORKNUM file with wrapper
table_create_init_fork.

Thomas Munro sent in another revision of a patch to add a synchronous replay
mode for avoiding stale reads on hot standbys.

Tom Lane sent in a patch to process SIGPIPE normally in COPY ... FROM PROGRAM.

Pavel Stěhule sent in another revision of a patch to implement schema variables.

Ryohei Nagaura sent in a patch to make it possible to use TCP_USER_TIMEOUT.

Hironobu SUZUKI and Fabien COELHO traded patches to pgbench to add pseudo-random
permutation function.

David Fetter sent in a patch to increase the default resolution of log
timestamps from milliseconds to microseconds.

Thomas Munro sent in another revision of a patch to add a WL_EXIT_ON_PM_DEATH
pseudo-event.

Andrey V. Lepikhov sent in two more revisions of a patch to fix handling of the
WAL record buffer pointer.

Fabien COELHO sent in two more revisions of a patch to fix some issues in how
libpq handles host IPs.

Michaël Paquier sent in a patch to fix an infelicity in handling userid
assignment with savepoints.

Álvaro Herrera sent in a patch to have isolationtester prefix WARNING with
session name.

Ryo Matsumura sent in a patch to add a BYTEA data type to ECPG.

David Rowley sent in a patch to make it obvious that there's meant to be exactly
1 item in the partexprs List for each zero-valued partattrs element.

MyungKyu LIM sent in another revision of a patch to add entry creation timestamp
column to pg_stat_replication.

Konstantin Knizhnik sent in another revision of a patch to add built-in
connection pooling.

Kyotaro HORIGUCHI sent in another revision of a patch to make
pg_verify_checksums conscious of unknown files and common-ize the file type
checker for checksums.

Marius Timmer sent in another revision of a patch to add a new auth option:
clientcert=verify-full.

Peter Eisentraut sent in another revision of a patch to lower the lock level for
renaming indexes.

Álvaro Herrera sent in another revision of a patch to reduce the locking needed
in order to ATTACH/DETACH partitions.

Nikolay Samokhvalov sent in a patch to better document fail-back, specifically
the conditions under which a previously failed publisher node can be made the
new publisher without running pg_rewind or similar.

Dmitry Dolgov sent in another revision of a patch to improve the algorithm for
partition-wise JOINs.

Kyotaro HORIGUCHI sent in two more revisions of a patch to add a WAL relief vent
for replication slots, and columns "status" and "remain" to pg_replication_slot,
which help monitor max_slot_wal_keep_size.

Ian Barwick sent in two revisions of a patch to document the new pg_promote
function.

Amit Langote sent in another revision of a patch to speed up planning with
partitions.

Fabien COELHO sent in a patch to fix psql \conninfo and \connect when using
hostaddr.

David Rowley sent in a patch to make ordered partitioned table scans by using
Append rather than MergeAppend in some cases when it can be shown to be the
correct thing to do.

Dilip Kumar sent in two revisions of a patch to fix a bug in childrel statistics
access.

Daniel Gustafsson sent in two revisions of a patch to consolidate option
checking in pg_restore.

Tomáš Vondra sent in another revision of a patch to add a WHEN option to COPY
... FROM.

Andrey Borodin sent in another revision of a patch to add GiST support to
VACUUM.

Tomáš Vondra sent in another revision of a patch to add a WITH TIES option to
FETCH FIRST.

Daniel Gustafsson sent in another revision of a patch to support the Secure
Transport SSL library on macOS as an OpenSSL alternative.

Tomáš Vondra sent in a patch to fix some tests in the upcoming JSONPATH patch.