| From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | CREATE/DROP ROLE transactional? GRANT/REVOKE? |
| Date: | 2023-03-06 13:19:04 |
| Message-ID: | CAFCRh-8Q0eFxYPtHf=WstE=2cJertKcjP9k-BjBnTnkBr4B+aw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
[1]: https://www.postgresql.org/docs/current/sql-droprole.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Wienhold | 2023-03-06 14:02:29 | Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? |
| Previous Message | vignesh C | 2023-03-06 13:13:51 | Re: Support logical replication of DDLs |