PostgreSQL Patch Tester

Here lives an experimental bot that does this: Commitfest → Github → ( AppVeyor, Travis ). You can find a report for the current CF, the next CF or individual patch authors.

News: Some information about this project can be seen in these slides from PGCon 2018. Since then the reliability problem with winbison has been fixed (thanks to David Fetter!) TL;DR: the plan discussed with the pginfra team is to integrate this into the Commitfest application. May take some time, but watch this space.

Ready for Committer

21/1898 Add sqlstate output mode to VERBOSITY patch   apply success   appveyor success   travis success
21/1869 Improvements to Postgres documentation "Getting started" tutorial for Google Cod... patch   apply failure
21/1677 New libpq option to prefer standby for connection Haribabu Kommi patch   apply success   appveyor success   travis success
21/1853 improve pgbench doc about prepared statements Tatsuo Ishii patch   apply success   appveyor success   travis success
21/1522 pg_hba.conf : new auth option : clientcert=verify-full Julian Markwort patch   apply success   appveyor success   travis success
21/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success   appveyor success   travis success
21/669 pgbench - allow to store query results into variables Fabien Coelho patch   apply success   appveyor success   travis success

Needs review

21/1884 ALTER INDEX ... ALTER COLUMN not present in dump Michael Paquier patch   apply success   appveyor success   travis success
21/1764 ALTER TABLE on system catalogs Peter Eisentraut patch   apply success   appveyor success   travis success
21/1909 ALTER TABLE synopsis : action keyword with two different usages Lætitia AVROT patch   apply success   appveyor success   travis success
21/1842 ATTACH/DETACH PARTITION CONCURRENTLY Álvaro Herrera, David Rowley patch   apply failure
21/1644 Add --include-table-data-where option to pg_dump, to export only a subset of tab... Carter Thaxton patch   apply failure
21/1883 Add Hook Functions for Disk Quota Extension Haozhou Wang, Hubert Zhang, Hao Wu patch   apply success   appveyor success   travis success
21/1882 Add client connection check during the execution of the query Sergey Cherkashin patch   apply failure
21/1489 Add enum releation option type Nikolay Shaplov patch   apply success   appveyor success   travis success
21/1855 Add options for COSTS and duration to auto_explain, and add tests Daniel Gustafsson patch   apply success   appveyor success   travis success
21/1906 Add pg_partition_root to get top-most parent of a partition tree Michael Paquier patch   apply success   appveyor success   travis success
21/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply success   appveyor success   travis success
21/1873 Adding a TAP test checking data consistency on standby with minRecoveryPoint Michael Paquier patch   apply success   appveyor success   travis success
21/1553 Advanced partition matching for partition-wise join Ashutosh Bapat patch   apply success   appveyor success   travis success
21/1890 Allow UNLISTEN during recovery patch   apply success   appveyor success   travis success
21/1908 Allow anonymous rowtypes in function return column definition Elvis Pranskevichus patch   apply success   appveyor success   travis success
21/1889 Allow partitions to inherit their tablespace from their parent David Rowley patch   apply success   appveyor success   travis success
21/1485 Applying PMDK to WAL operations for persistent memory yoshimi ichiyanagi patch   apply failure
21/1747 Autoprepare: implicitly replace literals with parameters and store generalized p... Konstantin Knizhnik patch   apply failure
21/1821 Avoid creation of the free space map for small tables John Naylor patch   apply success   appveyor success   travis success
21/1824 COPY FROM WHEN condition Surafel Temesgen patch   apply success   appveyor success   travis success
21/1891 Change pg_regress diffs to unified by default Christoph Berg patch   apply success   appveyor success   travis success
21/1863 Cleaning up orphaned files using undo logs Thomas Munro patch   apply failure
21/1867 Connection slots reserved for replication Alexander Kukushkin patch   apply success   appveyor success   travis success
21/1875 Convert MAX_SAOP_ARRAY_SIZE to new guc James Coleman patch   apply success   appveyor success   travis success
21/1615 Covering GiST indexes Andrey Borodin patch   apply success   appveyor success   travis success
21/1294 Custom compression methods Ildus Kurbangaliev patch   apply success   appveyor success   travis success
21/1803 DNS SRV support for LDAP authentication Thomas Munro patch   apply success   appveyor success   travis success
21/1887 Delay locking partitions during INSERT and UPDATE David Rowley patch   apply success   appveyor failure (new)   travis success
21/1897 Delay locking partitions during query execution David Rowley patch   apply success   appveyor success   travis success
21/1765 Detect shared buffer access violations using mprotect() Asim Rama Praveen patch   apply success   appveyor success   travis success
21/1868 Detoast Compressed Datum Slice Paul Ramsey patch   apply success   appveyor success   travis success
21/1664 Evaluate immutable functions during planning (in FROM clause) Aleksandr Parfenov patch   apply success   appveyor success   travis success
21/1759 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis success
21/1844 FETCH FIRST clause WITH TIES option Surafel Temesgen patch   apply success   appveyor failure (new)   travis success
21/1683 Fix cancelled queries when hot_standby_feedback = on Ivan Kartyshov patch   apply success   appveyor success   travis failure
21/528 Fix the optimization to skip WAL-logging on table created in same transaction Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi patch   apply failure
21/1421 Flexible configuration for full-text search Aleksandr Parfenov patch   apply failure
21/1877 Foreign keys referencing partitioned tables Álvaro Herrera patch   apply success   appveyor success   travis success
21/1647 GSSAPI encryption support Robbie Harwood patch   apply failure
21/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis success
21/1598 GiST VACUUM Constantine Kuznetsov, Andrey Borodin patch   apply success   appveyor success   travis success
21/1543 ICU as default collation provider Marina Polyakova patch   apply success   appveyor success   travis failure
21/1912 INSTALL file generation with Pandoc Peter Eisentraut patch   apply success (new)   appveyor success (new)   travis success (new)
21/1900 Improve documentation about run-time pruning Amit Langote patch   apply success   appveyor success   travis success
21/1901 Improve error about unsupported subscription target relations Amit Langote patch   apply success   appveyor success   travis success
21/1895 Improve tab completion for CREATE TABLE Dagfinn Ilmari Mannsåker patch   apply success   appveyor success   travis success
21/1741 Index Skip Scan Thomas Munro, Jesper Pedersen patch   apply success   appveyor success   travis success
21/1857 Installation instructions update (pg_ctl) Andreas 'ads' Scherbaum patch   apply success   appveyor success   travis success
21/1804 KNN for B-tree Nikita Glukhov patch   apply success   appveyor success   travis failure
21/1885 Log PostgreSQL version number on startup Christoph Berg patch   apply success   appveyor failure (new)   travis success
21/944 Logical decoding of two-phase transactions Nikhil Sontakke patch   apply failure
21/1446 MERGE Simon Riggs, Pavan Deolasee patch   apply success   appveyor success   travis success
21/1672 Make installcheck-world in a clean environment Alexander Lakhin patch   apply success   appveyor success   travis success
21/1787 Make nbtree keys unique by appending heap TID, suffix truncation Peter Geoghegan patch   apply success   appveyor success   travis success
21/1827 Make the planner treat empty jointrees as selecting from a new dummy RTE type Tom Lane patch   apply success   appveyor success   travis success
21/1820 NOTIFY and pg_notify performance when deduplicating notifications Julien Demoor patch   apply success   appveyor failure   travis failure
21/1733 Online verification of checksums Michael Banck patch   apply failure
21/1850 Ordered Partitioned Table Scans David Rowley patch   apply success   appveyor success   travis success
21/1886 Pass COPT and PROFILE to CXXFLAGS Christoph Berg patch   apply success   appveyor success   travis success
21/1283 Pluggable storage API Álvaro Herrera, Alexander Korotkov, Haribabu Kommi patch   apply failure
21/1879 Prove IS NOT NULL inference for large arrays James Coleman patch   apply success   appveyor success   travis success
21/1578 Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist Anastasia Lubennikova, Andrey Lepikhov patch   apply success   appveyor success   travis success
21/1829 Refactoring the checkpointer's fsync request queue Thomas Munro patch   apply failure
21/1712 Remove self join on a unique column Alexander Kuzmenkov patch   apply success   appveyor failure (new)   travis failure
21/1353 Removing [Merge]Append nodes which contain a single subpath David Rowley patch   apply success   appveyor success   travis success
21/1626 Replace conversion_create.sql with normal data entries John Naylor patch   apply success   appveyor success   travis success
21/621 Respect client-initiated CopyDone during logical streaming replication Dave Cramer, Vladimir Gordiychuk patch   apply success   appveyor success   travis failure
21/1802 Retail IndexTuple Deletion Andrey Lepikhov patch   apply success   appveyor failure   travis failure
21/1799 SERIALIZABLE on standby servers Thomas Munro patch   apply success   appveyor success   travis success
21/1004 SERIALIZABLE with parallel query Thomas Munro patch   apply success   appveyor success   travis success
21/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
21/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor success   travis success
21/1461 Shared Ispell dictionaries Arthur Zakirov patch   apply success   appveyor success   travis success
21/1778 Speed up planning with partitions Amit Langote patch   apply success   appveyor success   travis success
21/1910 Statement-level rollback Álvaro Herrera, Takayuki Tsunakawa patch   apply success   appveyor failure   travis success
21/1767 Strengthen PGSharedMemoryCreate checks for still-attached processes Noah Misch patch   apply success   appveyor success   travis success
21/1589 Synchronous replay mode for avoiding stale reads on hot standbys Thomas Munro patch   apply failure (new)   appveyor success   travis success
21/1755 Tid scan improvements (ordering and range scan) Edmund Horner patch   apply success   appveyor success   travis success
21/1718 Track the next xid using 64 bits Thomas Munro patch   apply success   appveyor success   travis success
21/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply failure
21/1602 Two pass check for deadlock Yura Sokolov patch   apply success   appveyor success   travis success
21/1828 Undo worker and transaction rollback Amit Kapila, dilip kumar, mithun cy, Rafia Sabih patch   apply failure
21/1870 Update INSTALL file Andreas 'ads' Scherbaum
21/1834 Use single-byte Boyer-Moore-Horspool search even with multibyte encodings. Heikki Linnakangas patch   apply success   appveyor success   travis failure
21/1085 XML XPath default namespace support Pavel Stehule patch   apply success   appveyor success   travis success
21/1872 XMLTABLE Pavel Stehule patch   apply success   appveyor failure   travis failure
21/1594 chained transactions Peter Eisentraut patch   apply success   appveyor success   travis success
21/1911 commontype and commontypearray polymorphic types Pavel Stehule patch   apply success   appveyor success   travis success
21/1893 create and use subscription for nonsuperuser patch   apply success   appveyor success   travis failure
21/1619 de-deduplicate code in DML execution hooks in postgres_fdw Ashutosh Bapat patch   apply success   appveyor success   travis success
21/1796 documenting signal handling with readme Chris Travers patch   apply success   appveyor success   travis success
21/1904 don't create storage when unnecessary Álvaro Herrera patch   apply success   appveyor success   travis success
21/1620 generalized expression syntax for partition bounds Tom Lane, Kyotaro Horiguchi, Amit Langote patch   apply success   appveyor success   travis success
21/1443 generated columns Peter Eisentraut patch   apply failure
21/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply success   appveyor failure   travis success
21/1892 idle-in-transaction timeout error does not give a hint Tatsuo Ishii patch   apply success   appveyor success   travis success
21/1635 libpq compression Konstantin Knizhnik patch   apply success   appveyor success   travis success
21/1769 libpq host/hostaddr consistency Fabien Coelho patch   apply success   appveyor success   travis success
21/1854 libpq trace log Aya Iwata patch   apply success   appveyor success   travis failure
21/1852 logical decoding Segmentation fault (predicate index causing crash) Álvaro Herrera, Petr Jelínek patch   apply failure
21/1490 macOS Secure Transport SSL Support Daniel Gustafsson patch   apply success   appveyor failure   travis failure
21/1903 minor fix in CancelVirtualTransaction Álvaro Herrera patch   apply success   appveyor success   travis success
21/1896 online change primary_conninfo Sergei Kornilov patch   apply success   appveyor success   travis success
21/1832 pg_dump multi VALUES INSERT Surafel Temesgen patch   apply failure
21/1907 pg_partition_tree crashes for a non-defined relation Michael Paquier patch   apply success   appveyor building   travis building
21/1849 pg_rewind: options to use restore_command from recovery.conf or command line Alexey Kondratov patch   apply success   appveyor success   travis success
21/1833 pg_stat_ssl additions Peter Eisentraut patch   apply failure (new)   appveyor success   travis success
21/1707 pg_stat_statements_reset() update to reset specific statement statistics Haribabu Kommi patch   apply success   appveyor success   travis success
21/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply success   appveyor success   travis success
21/1881 plpgsql unique statement id Pavel Stehule patch   apply success   appveyor success   travis success
21/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
21/1899 psql display of foreign keys Álvaro Herrera patch   apply success   appveyor success   travis success
21/1905 rewrite ExecPartitionCheckEmitError Álvaro Herrera patch   apply success   appveyor success   travis success
21/1608 schema variables, LET command Pavel Stehule patch   apply failure
21/1874 support VARIADIC arg for least/greatest functions Pavel Stehule patch   apply success   appveyor failure   travis failure
21/1902 timeout parameters in libpq Ryohei Nagaura patch   apply success   appveyor success   travis success
21/1389 verify ALTER TABLE SET NOT NULL by valid constraints Sergei Kornilov patch   apply success   appveyor success   travis success

Waiting on Author

21/1319 Add ALWAYS DEFERRED option for CONSTRAINTs and CONSTRAINT TRIGGERs Nicolas Williams patch   apply failure
21/1090 Add and report the new "session_read_only" GUC pseudo-variable. Elvis Pranskevichus patch   apply failure
21/1819 Allow AddForeignUpdateTargets to add extra target expressions other than columns Etsuro Fujita, Kyotaro Horiguchi patch   apply failure
21/1783 Allow has_table_previlege to return false when user has no previlege on namespac... Yugo Nagata patch   apply success   appveyor failure   travis failure
21/1348 BRIN bloom and multi-minmax indexes Tomas Vondra patch   apply failure
21/1774 Block level parallel vacuum Masahiko Sawada patch   apply success   appveyor success   travis failure
21/1894 Change "checkpoint starting" message to use "wal" Christoph Berg patch   apply success   appveyor success   travis success
21/1705 Copy function for logical replication slots Masahiko Sawada patch   apply success   appveyor success   travis success
21/1651 GROUP BY optimization Fedor Sigaev patch   apply failure
21/1695 Global shared meta cache Takeshi Ideriha patch   apply success   appveyor success   travis success
21/1662 Global snapshots Stas Kelvich, Konstantin Knizhnik patch   apply success   appveyor failure   travis failure
21/1604 Implement ASSERTIONs per the SQL standard. Joe Wildish patch   apply failure
21/1807 Implement predicate propagation for non-equivalence clauses. Richard Guo patch   apply success   appveyor success   travis failure
21/1734 Inline Common Table Expressions Andrew Gierth, David Fetter patch   apply success   appveyor success   travis success
21/1817 New vacuum option to do only freezing Masahiko Sawada patch   apply success   appveyor success   travis success
21/1535 Online enabling of checksums Magnus Hagander, Daniel Gustafsson patch   apply failure
21/1786 Progress reporting for pg_verify_checksums Bernd Helmle, Michael Banck patch   apply success   appveyor failure   travis failure
21/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor failure   travis failure
21/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply success   appveyor success   travis success
21/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply failure
21/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply success   appveyor failure   travis failure
21/1862 Row filtering for logical replication Euler Taveira patch   apply failure
21/1704 SQL/JSON: documentation Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor success   travis success
21/1471 SQL/JSON: jsonpath Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor success   travis success
21/1460 Sample values for pg_stat_statements Vik Fearing patch   apply failure
21/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply success   appveyor failure   travis failure
21/1731 Show size of partitioned table Pavel Stehule patch   apply failure
21/1670 Support optional message in backend cancellation/termination Daniel Gustafsson patch   apply failure
21/1649 Undo logs dilip kumar, Thomas Munro patch   apply failure
21/1648 WIP: Precalculate stable functions Arthur Zakirov, Marina Polyakova patch   apply failure
21/1800 amcheck verification for GiST Andrey Borodin patch   apply success   appveyor success   travis success
21/1745 conflict handling for COPY FROM Surafel Temesgen patch   apply failure
21/1706 cost_sort improvement Fedor Sigaev patch   apply success   appveyor failure   travis failure
21/1631 hostorder and failover_timeout for libpq Ildar Musin patch   apply failure
21/1238 multivariate MCV lists and histograms Tomas Vondra patch   apply success   appveyor success   travis failure
21/1860 pg_dumpall --exclude-database option Andrew Dunstan patch   apply success   appveyor building   travis building

Please send feedback to thomas.munro-at-enterprisedb.com.