Archiwizowane November, 2009

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 ...

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 ...

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 ...

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 ...

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 ...

November 1st, 2009 by depesz | Tags: , , , , , | 2 comments »

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 ...