On 28th of July, Simon Riggs committed patch which: Log Message: ———– Reduce LOCK levels OF CREATE TRIGGER AND SOME ALTER TABLE, CREATE RULE actions. Avoid hard-coding lockmode used FOR many altering DDL commands, allowing easier future changes OF LOCK levels. Implementation OF initial analysis ON DDL sub-commands, so that many LOCK levels are now … Continue reading “Waiting for 9.1 – Reduced lock levels for ALTER TABLE”
On 25th Robert Haas committed patch which adds first of ‘CREATE IF NOT EXISTS’ commands: Log Message: ———– CREATE TABLE IF NOT EXISTS. Reviewed BY Bernd Helmle.
On 20th of July, Robert Haas committed (and later committed change to it) patch which adds another \* command to psql: Log Message: ———– Add \conninfo command to psql, to show current connection info. David Christensen. Reviewed by Steve Singer. Some further changes by me.
Generally I write about new features, but this change is relatively important. Yesterday, on 20th of July, Robert Haas committed following change: Log Message: ———– Change the default value of standard_conforming_strings to on. This change should be publicized to driver maintainers at once and release-noted as an incompatibility with previous releases.
As of now, I am happy user of 9.1devel version of PostgreSQL: =$ psql -c ‘select version()’ version ——————————————————————————————————————— PostgreSQL 9.1devel ON x86_64-unknown-linux-gnu, compiled BY GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit (1 ROW) So, I guess no new features will make it to 9.0 – after all, 9.0 is currently already beta3. If you want … Continue reading “Waiting for 9.0 – Final Post ?”
On May, 12ve, Bruce Momjian committed new contrib module for 9.0 – pg_upgrage. As I understand – this is what was available before as pg-migrator. If you’re not familiar with it – it’s a tool that allows upgrade of $PGDATA from some version to some version. What’s the use case? Let’s assume you have this … Continue reading “Waiting for 9.0 – pg_upgrade”
UPDATE Please read also about this change in Pg 9.1, and this change in Pg 9.2 posts, as they explain that since Pg 9.1 some of the limitations listed in this post are no longer there. END OF UPDATE Fight! But more seriously – people tend to use various data types, and there have been … Continue reading “CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03”
First of all – I base information in this post on Linux, so if you are using another operating system – it’s quite likely that it will not help you. Second – if you’re using Linux, you have probably some package manager – dpkg, rpm, pacman, poldek, whatever. Right? So, it should be easy to … Continue reading “Installing PostgreSQL”
On 12th of February Tom Lane committed patch by Hitoshi Harada: Log Message: ———– Extend the set of frame options supported for window functions. This patch allows the frame to start from CURRENT ROW (in either RANGE or ROWS mode), and it also adds support for ROWS n PRECEDING and ROWS n FOLLOWING start … Continue reading “Waiting for 9.0 – extended frames for window functions”
On 1st of Februyary, Takahiro Itagaki committed a patch by Pavel Stehule which adds string_agg aggregate: Log Message: ———– Add string_agg aggregate functions. The one argument version concatenates the input values into a string. The two argument version also does the same thing, but inserts delimiters between elements. Original patch by Pavel Stehule, reviewed … Continue reading “Waiting for 9.0 – string_agg”