Extend CREATE POLICY to add IF EXISTS - Mailing list pgsql-general

From Paul Austin
Subject Extend CREATE POLICY to add IF EXISTS
Date
Msg-id CWXP265MB500957DD1918490CD4AB439EF7F5A@CWXP265MB5009.GBRP265.PROD.OUTLOOK.COM
Whole thread Raw
Responses RE: Extend CREATE POLICY to add IF EXISTS
List 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

pgsql-general by date:

Previous
From: Michał Kłeczek
Date:
Subject: Re: Arrays vs separate tables
Next
From: Paul Austin
Date:
Subject: RE: Extend CREATE POLICY to add IF EXISTS