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:06:12
Message-ID: 3351044.1678115172@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:
> Hi. Perhaps I missed it in the doc (e.g. [1]), but are DDLs around ROLEs
> and GRANTs transactional?

Your expectation is set wrongly. DDL commands in Postgres are
transactional unless their man page explicitly says they're not.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2023-03-06 15:25:24 Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
Previous Message Erik Wienhold 2023-03-06 14:02:29 Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?