Extend CREATE POLICY to add IF EXISTS

From: Paul Austin <paul(dot)austin(at)automutatio(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Extend CREATE POLICY to add IF EXISTS
Date: 2025-10-20 21:45:56
Message-ID: CWXP265MB500957DD1918490CD4AB439EF7F5A@CWXP265MB5009.GBRP265.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Austin 2025-10-20 21:49:12 RE: Extend CREATE POLICY to add IF EXISTS
Previous Message Michał Kłeczek 2025-10-20 15:41:54 Re: Arrays vs separate tables