Waiting for 9.1 – auth_delay
On 27th of November, Robert Haas committed patch which adds new, interesting contrib module: New contrib module, auth_delay. KaiGai Kohei, with a few changes by me.
On 27th of November, Robert Haas committed patch which adds new, interesting contrib module: New contrib module, auth_delay. KaiGai Kohei, with a few changes by me.
On 21st of November Robert Haas committed new patch, which adds new function: Add new SQL function, format(text). Currently, three conversion format specifiers are supported: %s for a string, %L for an SQL literal, and %I for an SQL identifier. The latter two are deliberately designed not to overlap with what sprintf() already supports, in … Continue reading “Waiting for 9.1 – format()”
On 8th of November, Tom Lane committed patch, which doesn’t provide any new features, but removes one of the more annoying footguns in PostgreSQL: Prevent invoking I/O conversion casts via functional/attribute notation. PG 8.4 added a built-in feature for casting pretty much any data type to string types (text, varchar, etc). We allowed this … Continue reading “Waiting for 9.1 – Removed autocast footgun”
Finally, on 25th of October, Tom Lane committed patch which does: Allow new values to be added to an existing enum type. After much expenditure of effort, we’ve got this to the point where the performance penalty is pretty minimal in typical cases. Andrew Dunstan, reviewed by Brendan Jurd, Dean Rasheed, and Tom … Continue reading “Waiting for 9.1 – adding values to enums”
On 24th of October, Peter Eisentraut committed addition to his previous patch, which adds: Support suffix matching of host names in pg_hba.conf A name starting with a dot can be used to match a suffix of the actual host name (e.g., .example.com matches foo.example.com).
On 15th of October Peter Eisentraut committed patch (his own) which adds: Support host names in pg_hba.conf Peter Eisentraut, reviewed by KaiGai Kohei and Tom Lane
On 10th of October, Tom Lane committed patch by Deal Rasheed, which adds triggers on views: Support triggers ON views. This patch adds the SQL-standard concept OF an INSTEAD OF TRIGGER, which IS fired instead OF performing a physical INSERT/UPDATE/DELETE. The TRIGGER FUNCTION IS passed the entire OLD AND/OR NEW ROWS OF the VIEW, … Continue reading “Waiting for 9.1 – triggers on views”
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
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.
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 … Continue reading “Waiting for 9.1 – Recognize functional dependency on primary keys.”