RE: Extend CREATE POLICY to add IF EXISTS

Поиск
Список
Период
Сортировка
От Paul Austin
Тема RE: Extend CREATE POLICY to add IF EXISTS
Дата
Msg-id CWXP265MB500928C799DB70B9A6EDB4D4F7F5A@CWXP265MB5009.GBRP265.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Extend CREATE POLICY to add IF EXISTS  (Paul Austin <paul.austin@automutatio.com>)
Ответы Re: Extend CREATE POLICY to add IF EXISTS
Список pgsql-general

I forgot DROP POLICY already has IF EXISTS

 

From: Paul Austin <paul.austin@automutatio.com>
Sent: October 20, 2025 2:46 PM
To: pgsql-general@lists.postgresql.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

В списке pgsql-general по дате отправления: