Chris van Eijk: CREATE POLICY IF NOT EXISTS in PostgreSQL: what works

T2Covered by 1 source · first reported by Planet PostgreSQL at 16 Oct, 00:00 UTC

PostgreSQL has no CREATE POLICY IF NOT EXISTS. Three ways to write a repeatable policy migration, measured on PostgreSQL 17 and 18: gaps, locks and races.

cloud

Sources

• T2Chris van Eijk: CREATE POLICY IF NOT EXISTS in PostgreSQL: what worksPlanet PostgreSQL16 Oct, 00:00