Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dominique Devienne <ddevienne(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
Date: 2023-03-06 15:31:52
Message-ID: 3353928.1678116712@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dominique Devienne <ddevienne(at)gmail(dot)com> writes:
> On Mon, Mar 6, 2023 at 4:06 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> DDL commands in Postgres are
>> transactional unless their man page explicitly says they're not.

> Could you point to where in the doc this is stated?

For example, for CREATE DATABASE the first "Note" para in [1] is

CREATE DATABASE cannot be executed inside a transaction block.

I don't think we are entirely consistent about whether this is
mentioned in "Description" or "Notes", but it's there somewhere.

regards, tom lane

[1] https://www.postgresql.org/docs/current/sql-createdatabase.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2023-03-06 15:34:52 Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
Previous Message Dominique Devienne 2023-03-06 15:25:24 Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?