Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Cc: Israel Barth Rubio <barthisrael(at)gmail(dot)com>, Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands
Date: 2022-12-13 19:26:58
Message-ID: 2495271.1670959618@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

I wrote:
> Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> writes:
>> The case I was working on is the same as Israel's. He has confirmed
>> that this fixes the issue we have been working on.

> OK, I'll make this happen soon.

Pushed. I left out the idea of making this conditional on whether
any preceding command had performed data modification, as that seemed
to greatly complicate the explanation (since "have we performed any
data modification" is a rather squishy question from a user's viewpoint).

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-12-13 21:02:56 BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18
Previous Message PG Bug reporting form 2022-12-13 18:59:18 BUG #17718: Unexpected REVOKE ALL permissions in the backup script

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2022-12-13 22:13:24 Re: Remove SHA256_HMAC_B from scram-common.h
Previous Message Ilya Gladyshev 2022-12-13 19:07:06 Re: Progress report of CREATE INDEX for nested partitioned tables