On 26th of September, Peter Eisentraut committed patch which adds:
Add ALTER TYPE ... ADD/DROP/ALTER/RENAME ATTRIBUTE Like with tables, this also requires allowing the existence of composite types with zero attributes. reviewed by KaiGai Kohei
Tag: waiting
Waiting for 9.1 – concat, concat_ws, right, left, reverse
On 24th of August, Takahiro Itagaki committed patch:
Log Message: ----------- Add string functions: concat(), concat_ws(), left(), right(), and reverse(). Pavel Stehule, reviewed by me.
Continue reading Waiting for 9.1 – concat, concat_ws, right, left, reverse
Waiting for 9.1 – Recognize functional dependency on primary keys.
Yesterday (August, 7th), Tom Lane committed:
Log Message: ----------- Recognize functional dependency on primary keys. This allows a table's other columns to be referenced without listing them in GROUP BY, so long as the primary key column(s) are listed in GROUP BY. Eventually we should also allow functional dependency on a UNIQUE constraint when the columns are marked NOT NULL, but that has to wait until NOT NULL constraints are represented in pg_constraint, because we need to have pg_constraint OIDs for all the conditions needed to ensure functional dependency. Peter Eisentraut, reviewed by Alex Hunsaker and Tom Lane
Continue reading Waiting for 9.1 – Recognize functional dependency on primary keys.
Waiting for 9.1 – Reduced lock levels for ALTER TABLE
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 at ShareUpdateExclusiveLock or ShareRowExclusiveLock, allowing certain DDL not to block reads/writes. First of number of planned changes in this area; additional docs required when full project complete.
Continue reading Waiting for 9.1 – Reduced lock levels for ALTER TABLE
Waiting for 9.1 – CREATE TABLE IF NOT EXISTS
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.
Continue reading Waiting for 9.1 – CREATE TABLE IF NOT EXISTS
Waiting for 9.1 – \conninfo in psql
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.
Waiting for 9.1 – standard_conforming_strings = on
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.
Continue reading Waiting for 9.1 – standard_conforming_strings = on
Waiting for 9.0 – Final Post ?
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 to get list of what I wrote about for 8.5/9.0 – just check the tag page.
Dream wishlist for 9.1
Relatively soon we will have 9.0, and we will move with development to 9.1 (we as in: PostgreSQL community, I don't know C so I can't help developing myself, but I will at least try to keep up with changes in the ‘Waiting for' series).
Waiting for 9.0 – pg_upgrade
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 200GB database working as 8.3, and you'd like to go to 8.4 (or 9.0). Normal way is pg_dump + pg_restore – which will take some time. With pg-migrate/pg_upgrade it should be faster, and easier. So, let's play with it.