Search Results for: waiting for

Waiting for 8.5 – PL/pgSQL variable resolution

On 13th of November (I know, backlog again), Tom Lane committed patch which make PostgreSQL more strict about what happens in stored procedures in PL/pgSQL: Add control knobs for plpgsql’s variable resolution behavior, and make the default be "throw error on conflict", as per discussions. The GUC variable is plpgsql.variable_conflict, with values "error", "use_variable", "use_column". … Continue reading “Waiting for 8.5 – PL/pgSQL variable resolution”

Waiting for 8.5 – TRIGGERS on columns

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”

Waiting for 8.5 – Named function arguments

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

Waiting for 8.5 – GUC per user and database

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”

Waiting for 8.5 – “GRANT ALL”

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

Waiting for 8.5 – ‘samehost’ and ‘samenet’ in pg_hba.conf

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”

Waiting for 8.5 – DO

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”

Waiting for 8.5 – changes in hstore

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”

Waiting for 8.5 – Machine readable EXPLAIN

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