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””
October, finally. “Only” 1 month of backlog in new features in 8.5, but I’m getting there 🙂 So, on 1st of October Tom Lane committed patch by Stef Walter: Log Message: ———– Support "samehost" and "samenet" specifications in pg_hba.conf, by enumerating the machine’s IP interfaces to look for a match. Stef Walter For some … Continue reading “Waiting for 8.5 – ‘samehost’ and ‘samenet’ in pg_hba.conf”
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”
On 29th of September (I know, there is a backlog – I’ll work on it, I promise), Tom Lane committed another patch from Pavel Stehule: Allow MOVE FORWARD n, MOVE BACKWARD n, MOVE FORWARD ALL, MOVE BACKWARD ALL in plpgsql. Clean up a couple of corner cases in the MOVE/FETCH syntax. Pavel Stehule
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?