Skip to content

PostgreSQL

Version 5.3.0

Changed

  • A create is a create. CREATE FUNCTION, CREATE PROCEDURE, and CREATE VIEW render without OR REPLACE when the plan is creating; the in-place forms render only for the new replace actions, where the plan knows the object exists.
  • Trigger changes replace in place. A changed trigger renders as CREATE OR REPLACE TRIGGER instead of a drop and a create.

Fixed

  • Functions no longer fail to create when they reference tables from the same plan. NSchema.Core 5.3 orders routines after the tables they may reference, so a LANGUAGE sql body or a rowtype signature resolves during a rebuild.