Postgres Pro
Downloads
Home   >   mailing lists

CREATE/DROP ROLE transactional? GRANT/REVOKE? - Mailing list pgsql-general

From Dominique Devienne
Subject CREATE/DROP ROLE transactional? GRANT/REVOKE?
Date
Msg-id CAFCRh-8Q0eFxYPtHf=WstE=2cJertKcjP9k-BjBnTnkBr4B+aw@mail.gmail.com
Whole thread Raw
Responses Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?  (Erik Wienhold <ewie@ewie.name>)
Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Hi. Perhaps I missed it in the doc (e.g. [1]), but are DDLs around ROLEs and GRANTs transactional?

Since I'm creating many ROLEs and making many GRANTs, based info I read from PostgreSQL itself (in pg_catalog and elsewhere), should everything be in a single transaction?

FWIW, I come from Oracle (where DDL is non-transactional and an implicit COMMIT), and SQLite (where ROLEs and GRANTs don't apply), thus this perhaps silly question.

I'm already aware that SCHEMAs, TABLEs, etc... are transactionally created.
But given that ROLEs are cluster-wide, and the doc on DDLs say nothing, I prefer to ask.

Thanks, --DD

pgsql-general by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Row Level Security Policy Name in Error Message
Next
From: Erik Wienhold
Date:
Subject: Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?