On 20th of November Tom Lane committed patch by Takahiro Itagaki which adds interesting functionality: ADD a WHEN clause TO CREATE TRIGGER, allowing a BOOLEAN expression TO be checked TO determine whether the TRIGGER should be fired. FOR BEFORE triggers this IS mostly a matter OF spec compliance; but FOR AFTER triggers it can … Continue reading “Waiting for 8.5 – conditional triggers”
On 14th of October Tome Lane committed new patch from Itagaki Tahahiro: Log Message: ———– Support SQL-compliant triggers ON COLUMNS, ie fire ONLY IF certain COLUMNS are named IN the UPDATE’s SET list. Note: the schema of pg_trigger has not actually changed; we’ve just started TO USE a COLUMN that was there ALL along. … Continue reading “Waiting for 8.5 – TRIGGERS on columns”
Pavel Stehule – hero for everybody writing stored procedures, wrote, and later Tom Lane committed patch which adds named arguments for functions: Log Message: ———– Support use of function argument names to identify which actual arguments match which function parameters. The syntax uses AS, for example funcname(value AS arg1, anothervalue AS arg2) Pavel Stehule
On 7th of October Alvaro Herrera committed his own patch, which adds quite interesting possibilty: Log Message: ———– Make it possibly TO specify GUC params per USER AND per DATABASE. CREATE a NEW catalog pg_db_role_setting WHERE they are now stored, AND better encapsulate the code that deals WITH settings INTO its realm. The OLD … Continue reading “Waiting for 8.5 – GUC per user and database”
One of the most common (or perhaps even the most common) question people have regarding PostgreSQL, is how to change privileges for all tables. Usually they want something like MySQL’s: GRANT … ON DATABASE.* TO … Which is interesting as it is actually 2 distinct features in one: grant privileges on all existing tables automatically … Continue reading “Waiting for 8.5 – “GRANT ALL””
On 22nd of September, Tom Lane committed a patch by Petr Jelinek: Log Message: ———– Implement the DO statement TO support execution OF PL code WITHOUT HAVING TO CREATE a FUNCTION FOR it. PROCEDURAL languages now have an additional entry point, namely a FUNCTION TO EXECUTE an inline code block. This seemed a better … Continue reading “Waiting for 8.5 – DO”
Andrew Gierth (RhodiumToad on irc) wrote, and Tom Lane committed: Assorted improvements in contrib/hstore. Remove the 64K limit on the lengths of keys and values within an hstore. (This changes the on-disk format, but the old format can still be read.) Add support for btree/hash opclasses for hstore — this is not so much … Continue reading “Waiting for 8.5 – changes in hstore”
After very long discussions, on 10th of August, Tom Lane committed patch by Robert Haas: Log Message: ———– Extend EXPLAIN to support output in XML or JSON format. There are probably still some adjustments to be made in the details of the output, but this gets the basic structure in place. Robert Haas
On 3rd of August, Tatsuo Ishii committed patch by ITAGAKI Takahiro: Log Message: ———– Multi-threaded version of pgbench contributed by ITAGAKI Takahiro, reviewed by Greg Smith and Josh Williams. Following is the proposal from ITAGAKI Takahiro: Pgbench is a famous tool to measure postgres performance, but nowadays it does not work well because … Continue reading “Waiting for 8.5 – Multi-threaded pgbench”
Robert Haas wrote, and Tom Lane committed (on 2nd of August) patch which adds interesting capability: Log Message: ———– ADD ALTER TABLE … ALTER COLUMN … SET STATISTICS DISTINCT Robert Haas Log message is rather terse, so what does it exactly do?