Re: CREATE ROLE IF NOT EXISTS

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: David Christensen <david(dot)christensen(at)crunchydata(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE ROLE IF NOT EXISTS
Date: 2021-11-03 10:51:59
Message-ID: 0EBDBD07-B739-4565-96A2-ED1233E760E9@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 19 Oct 2021, at 22:12, David Christensen <david(dot)christensen(at)crunchydata(dot)com> wrote:
>
> Greetings -hackers,
>
> Enclosed is a patch that implements CREATE ROLE IF NOT EXISTS (along with the same support for USER/GROUP). This is a fairly straightforward approach in that we do no validation of anything other than existence, with the user needing to ensure that permissions/grants are set up in the proper way.
>
> Comments?

This fails the roleattributes test in "make check", with what seems to be a
trivial change in the output. Can you please submit a rebased version fixing
the test?

--
Daniel Gustafsson https://vmware.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2021-11-03 11:02:53 Re: stat() vs ERROR_DELETE_PENDING, round N + 1
Previous Message Daniel Gustafsson 2021-11-03 10:35:31 Re: [PATCH] Proof of concept for GUC improvements