public inbox for [email protected]  

help / color / mirror / Atom feed

From: Paul Austin <[email protected]>
To: Paul Austin <[email protected]>
To: [email protected] <[email protected]>
Subject: RE: Extend CREATE POLICY to add IF EXISTS
Date: Mon, 20 Oct 2025 21:49:12 +0000
Message-ID: <CWXP265MB500928C799DB70B9A6EDB4D4F7F5A@CWXP265MB5009.GBRP265.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CWXP265MB500957DD1918490CD4AB439EF7F5A@CWXP265MB5009.GBRP265.PROD.OUTLOOK.COM>
References: <CWXP265MB500957DD1918490CD4AB439EF7F5A@CWXP265MB5009.GBRP265.PROD.OUTLOOK.COM>

I forgot DROP POLICY already has IF EXISTS

From: Paul Austin <[email protected]>
Sent: October 20, 2025 2:46 PM
To: [email protected]
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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: RE: Extend CREATE POLICY to add IF EXISTS
  In-Reply-To: <CWXP265MB500928C799DB70B9A6EDB4D4F7F5A@CWXP265MB5009.GBRP265.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox