Re: CREATE/DROP ROLE transactional? GRANT/REVOKE?
| От | Dominique Devienne |
|---|---|
| Тема | Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? |
| Дата | |
| Msg-id | CAFCRh--=4MzsyoDXM1HRWs2AcrXc6CiWA0+HhRFpY5kpJrd65Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-general |
On Mon, Mar 6, 2023 at 4:31 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Dominique Devienne <ddevienne@gmail.com> writes:
> On Mon, Mar 6, 2023 at 4:06 PM Tom Lane <tgl@sss.pgh.pa.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.
Yes, I noticed that, once I read Erik's email (went to GMail's SPAM folder...).
Still, my little brain didn't leap to the conclusion that other DDLs were implicitly transactional,
because missing of a note another DDL's doc has. All I'm saying it's not as obvious as you
experienced PostgreSQL folks seems to think it is. FWIW. Thanks again, --DD
В списке pgsql-general по дате отправления: