On Mon, Mar 6, 2023 at 4:06 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Dominique Devienne <ddevie...@gmail.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. Thanks for the precision Tom. Although I'm not sure where you read my expectectation was wrong. But nevermind. > DDL commands in Postgres are > transactional unless their man page explicitly says they're not. > OK, didn't know that. Glad to read it. Could you point to where in the doc this is stated? It's hard to be sure about something the doc does *not* mention, when what is *implied* is hard to find, or at a distance. Especially at least another well known RDBMS differ in that department. I much prefer the way PostgreSQL handles DDL, still it's not obvious. My $0.02. Thanks, --DD
