Search Results for: waiting for 10

Waiting for PostgreSQL 10 – Implement syntax for transition tables in AFTER triggers.

Another one missed, quite a long time ago, too..: On 4th of November 2016, Kevin Grittner committed patch: Implement syntax for transition tables in AFTER triggers.     This is infrastructure for the complete SQL standard feature. No support is included at this point for execution nodes or PLs. The intent is to add that … Continue reading “Waiting for PostgreSQL 10 – Implement syntax for transition tables in AFTER triggers.”

Waiting for PostgreSQL 10 – Implement multivariate n-distinct coefficients

I missed it completely, but on 24th of March 2017, Alvaro Herrera committed patch: Implement multivariate n-distinct coefficients     Add support for explicitly declared statistic objects (CREATE STATISTICS), allowing collection of statistics on more complex combinations that individual table columns. Companion commands DROP STATISTICS and ALTER STATISTICS … OWNER TO / SET SCHEMA / … Continue reading “Waiting for PostgreSQL 10 – Implement multivariate n-distinct coefficients”

Waiting for PostgreSQL 10 – Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).

On 7th of March 2017, Heikki Linnakangas committed patch: Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).     This introduces a new generic SASL authentication method, similar to the GSS and SSPI methods. The server first tells the client which SASL authentication mechanism to use, and then the mechanism-specific SASL messages are exchanged in AuthenticationSASLcontinue … Continue reading “Waiting for PostgreSQL 10 – Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).”

Waiting for PostgreSQL 10 – Identity columns

On 6th of April 2017, Peter Eisentraut committed patch: Identity columns   This is the SQL standard-conforming variant of PostgreSQL’s serial columns. It fixes a few usability issues that serial columns have:   – CREATE TABLE / LIKE copies default but refers to same sequence – cannot add/drop serialness with ALTER TABLE – dropping default … Continue reading “Waiting for PostgreSQL 10 – Identity columns”

Waiting for PostgreSQL 10 – Support \if … \elif … \else … \endif in psql scripting.

On 30th of March 2017, Tom Lane committed patch: Support \if … \elif … \else … \endif in psql scripting.   This patch adds nestable conditional blocks to psql. The control structure feature per se is complete, but the boolean expressions understood by \if and \elif are pretty primitive; basically, after variable substitution and backtick … Continue reading “Waiting for PostgreSQL 10 – Support \if … \elif … \else … \endif in psql scripting.”

Waiting for PostgreSQL 10 – Logical replication support for initial data copy

On 23rd of March 2017, Peter Eisentraut committed patch: Logical replication support for initial data copy   Add functionality for a new subscription to copy the initial data in the tables and then sync with the ongoing apply process.   For the copying, add a new internal COPY option to have the COPY source data … Continue reading “Waiting for PostgreSQL 10 – Logical replication support for initial data copy”

Waiting for PostgreSQL 10 – hash indexing vs. WAL

For a long time hash indexed were not crash safe, and couldn’t be used on replication slave, because they skipped WAL. Now, thanks to these two commits, it has changed: On 14th of March 2017, Robert Haas committed patch: hash: Add write-ahead logging support.   The warning about hash indexes not being write-ahead logged and … Continue reading “Waiting for PostgreSQL 10 – hash indexing vs. WAL”

Waiting for PostgreSQL 10 – Support XMLTABLE query expression

On 8th of March, Alvaro Herrera committed patch: XMLTABLE is defined by the SQL/XML standard as a feature that allows turning XML-formatted data into relational form, so that it can be used as a <table primary> in the FROM clause of a query.   This new construct provides significant simplicity and performance benefit for XML … Continue reading “Waiting for PostgreSQL 10 – Support XMLTABLE query expression”

Waiting for PostgreSQL 10 – psql: Add \gx command

On 7th of March, Stephen Frost committed patch: psql: Add \gx command   It can often be useful to use expanded mode output (\x) for just a single query. Introduce a \gx which acts exactly like \g except that it will force expanded output mode for that one \gx call. This is simpler than having … Continue reading “Waiting for PostgreSQL 10 – psql: Add \gx command”