On 1st of August Tom Lane committed patch from Itagaki Takahiro: Improve unique-constraint-violation error messages to include the exact values being complained of. In passing, also remove the arbitrary length limitation in the similar error detail message for foreign key violations. Itagaki Takahiro and later added an extension to it: Department of second … Continue reading “Waiting for 8.5 – better messages for unique violation”
On 29th of July ( I know, there is a long backlog in waiting for 8.5 series. I’m working on it :), Tom Lane committed patch by Dean Rasheed: Support deferrable uniqueness constraints. The current implementation fires an AFTER ROW trigger for each tuple that looks like it might be non-unique according to the … Continue reading “Waiting for 8.5 – deferrable uniqueness”
On 205h of July Andrew Dunstan committed patch by Andres Freund : Log Message: ———– DROP IF EXISTS FOR COLUMNS AND constraints. Andres Freund.
Also yesterday, and also Peter Eisentraut, committed patch by Guillaume Smet, which: Add log_line_prefix placeholder %e to contain the current SQL state Author: Guillaume Smet
Yesterday Peter Eisentraut committed a patch, written by Damien Clochard, that modifies \d output in psql: Have \d show child tables that inherit from the specified parent As per discussion, \d shows only the number of child tables, because that could be hundreds, when used for partitioning. \d+ shows the actual list. Author: … Continue reading “Waiting for 8.5 – Have \d show child tables that inherit from the specified parent”
Everybody wrote that 8.4 was released, so it’s not a news now. But. Starting from yesterday, my own PostgreSQL reports it’s version like this: # SELECT version(); version ———————————————————————————————————– PostgreSQL 8.5devel ON i686-pc-linux-gnu, compiled BY GCC gcc (GCC) 4.2.4 (Ubuntu 4.2.4-1ubuntu4), 32-bit (1 ROW) Which means: I can start new blog posts series.
For quite some time I’ve been posting about new features in 8.4. First post was over a year ago, on 16th of February 2008. Now, we just (yesterday) got nice surprise: beta is here: (depesz@[LOCAL]:5840) 12:39:15 [depesz] # SELECT version(); version ———————————————————————————————————– PostgreSQL 8.4beta1 ON i686-pc-linux-gnu, compiled BY GCC gcc (GCC) 4.2.4 (Ubuntu 4.2.4-1ubuntu3), 32-bit … Continue reading “Waiting for 8.4 – final post (?)”
Usually I write about new features in 8.4, but this time I’d like to write about feature that will be actually missing in 8.4. And thank God, it will be missing. On Mon, 09 Mar 2009 11:22:47 -0400 Greg Sabino Mullane wrote mail to pgsql-hackers list with his patch that removes -d switch from pg_dump. … Continue reading “Waiting for 8.4 – no more -d in pg_dump!”
On 2nd of February Andrew Dunstan committed his patch (with editing by Tom Lane) that: Log Message: ———– Provide for parallel restoration from a custom format archive. Each data and post-data step is run in a separate worker child (a thread on Windows, a child process elsewhere) up to the concurrent number specified by the … Continue reading “Waiting for 8.4 – parallel restoration of dumps”
On 22nd of January, Tom Lane committed patch by Stephen Frost, which adds column level privileges: Log Message: ———– Support column-level privileges, as required by SQL standard. Stephen Frost, with help from KaiGai Kohei and others