Search Results for: waiting for 9.3

Waiting for 9.3 – Add support for piping COPY to/from an external program.

On 27th of February, Heikki Linnakangas committed patch: Add support for piping COPY to/from an external program.   This includes backend "COPY TO/FROM PROGRAM ‘…’" syntax, and corresponding psql \copy syntax. Like with reading/writing files, the backend version is superuser-only, and in the psql version, the program is run in the client.   In the … Continue reading “Waiting for 9.3 – Add support for piping COPY to/from an external program.”

Waiting for 9.3 – Create a psql command \gset to store query results into psql variables

On 2nd of February, Tom Lane committed patch: Create a psql command \gset to store query results into psql variables.   This eases manipulation of query results in psql scripts.   Pavel Stehule, reviewed by Piyush Newe, Shigeru Hanada, and Tom Lane

Waiting for 9.3 – Allow a streaming replication standby to follow a timeline switch.

On 13th of December, Heikki Linnakangas committed patch: Allow a streaming replication standby to follow a timeline switch.   Before this patch, streaming replication would refuse to start replicating if the timeline in the primary doesn’t exactly match the standby. The situation where it doesn’t match is when you have a master, and two standbys, … Continue reading “Waiting for 9.3 – Allow a streaming replication standby to follow a timeline switch.”

Waiting for 9.3 – Support automatically-updatable views.

On 8th of December, Tom Lane committed patch: Support automatically-updatable views.   This patch makes "simple" views automatically updatable, without the need to create either INSTEAD OF triggers or INSTEAD rules. "Simple" views are those classified as updatable according to SQL-92 rules. The rewriter transforms INSERT/UPDATE/DELETE commands on such views directly into an equivalent command … Continue reading “Waiting for 9.3 – Support automatically-updatable views.”

Waiting for 9.3 – Background worker processes

On 6th of December, Alvaro Herrera committed patch: Background worker processes   Background workers are postmaster subprocesses that run arbitrary user-specified code. They can request shared memory access as well as backend database connections; or they can just use plain libpq frontend database connections.   Modules listed in shared_preload_libraries can register background workers in their … Continue reading “Waiting for 9.3 – Background worker processes”

Waiting for 9.3 – Implement SQL-standard LATERAL subqueries.

On 7th of August, Tom Lane committed patch: Implement SQL-standard LATERAL subqueries.   This patch implements the standard syntax of LATERAL attached to a sub-SELECT in FROM, and also allows LATERAL attached to a function in FROM, since set-returning function calls are expected to be one of the principal use-cases.   The main change here … Continue reading “Waiting for 9.3 – Implement SQL-standard LATERAL subqueries.”

Waiting for 9.3 – Event triggers

On 20th of July, Robert Haas committed patch: Make new event trigger facility actually do something.   Commit 3855968f328918b6cd1401dd11d109d471a54d40 added syntax, pg_dump, psql support, and documentation, but the triggers didn’t actually fire. With this commit, they now do. This is still a pretty basic facility overall because event triggers do not get a whole lot … Continue reading “Waiting for 9.3 – Event triggers”

Waiting for 9.3 – Add array_remove() and array_replace() functions.

On 11th of July, Tom Lane committed patch: Add array_remove() and array_replace() functions. <span class="refs"> <span class="head" title="heads/master"><a href="/gitweb/?p=postgresql.git;a=shortlog;h=refs/heads/master">master   These functions support removing or replacing array element value(s) matching a given search value. Although intended mainly to support a future array-foreign-key feature, they seem useful in their own right.   Marco Nenciarini and Gabriele … Continue reading “Waiting for 9.3 – Add array_remove() and array_replace() functions.”

Waiting for 9.3 – Dramatically reduce System V shared memory consumption.

On 28th of June, Robert Haas committed patch: Dramatically reduce System V shared memory consumption.   Except when compiling with EXEC_BACKEND, we’ll now allocate only a tiny amount of System V shared memory (as an interlock to protect the data directory) and allocate the rest as anonymous shared memory via mmap. This will hopefully spare … Continue reading “Waiting for 9.3 – Dramatically reduce System V shared memory consumption.”