CREATE POLICY IF NOT EXISTS

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: CREATE POLICY IF NOT EXISTS
Date: 2025-10-21 06:06:47
Message-ID: CACJufxHWTADPj0SoVnUEJh+UEZ4Yd3neDexznCjprMTmxptcUA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

People have complained about the lack of CREATE POLICY IF NOT EXISTS
syntax in [1].
The attached patch adds support for syntax "CREATE POLICY IF NOT EXISTS".

[1] https://postgr.es/m/CWXP265MB500957DD1918490CD4AB439EF7F5A@CWXP265MB5009.GBRP265.PROD.OUTLOOK.COM

Attachment Content-Type Size
v1-0001-CREATE-POLICY-IF-NOT-EXISTS.patch text/x-patch 8.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2025-10-21 06:11:26 Re: Invalid primary_slot_name triggers warnings in all processes on reload
Previous Message Michael Paquier 2025-10-21 05:57:00 Re: Extended Statistics set/restore/clear functions.