RE: Extend CREATE POLICY to add IF EXISTS

I forgot DROP POLICY already has IF EXISTS

From: Paul Austin <paul(dot)austin(at)automutatio(dot)com>
Sent: October 20, 2025 2:46 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Extend CREATE POLICY to add IF EXISTS

Many (but not all) DDL statements use the pattern IF EXISTS or IF NOT EXISTS. This is really useful if you want to create a re-start-able data model update script without needing to have PL/pgSQL blocks that has checks to see if it exists.

An example of a statement that doesn't implement this pattern in the CREATE POLICY statement.

Is there a plan to add this pattern to the rest of the DDL statements? Or could it be added to the CREATE/DROP POLICY statements?

Thanks,
Paul