Release plx 1.3.0 · commandprompt/plx

plx 1.3.0 makes trigger row mutation available across the dialects and ships a verified cookbook for every dialect.

Added

plxtsql trigger row mutation. A Transact-SQL trigger can now assign to NEW fields with SET NEW.col = e, which lowers to NEW.col := e, so a trigger can rewrite the row and not only validate it. A SET with a qualified target and a top-level = is an assignment; SET NOCOUNT ON and other session options are still ignored. With the plxphp arrow assignment added in 1.2.2, assigning to a trigger's NEW fields is now supported across the dialects, each in its own idiom.
Cookbooks and limitations docs. A verified, runnable cookbook for each of the nine dialects (scalar functions, loops, string building, query loops, set-returning functions, error handling, triggers, dynamic SQL, and dialect idioms), and a consolidated gaps-and-limitations page. Both are on the documentation site.

No catalog changes. All 13 regression suites pass on PostgreSQL 13 through 18, plus 19beta and 20devel built from source.

Install the new module (make && make install), then:

ALTER EXTENSION plx UPDATE TO '1.3.0';

A fresh CREATE EXTENSION plx lands on 1.3.0 directly. The PGXN distribution zip (plx-1.3.0.zip) is attached.