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

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands
Дата
Msg-id
3995893.1668011885@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Yugo NAGATA <nagata@sraoss.co.jp>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Yugo NAGATA <nagata@sraoss.co.jp>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Yugo NAGATA <nagata@sraoss.co.jp>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Yugo NAGATA <nagata@sraoss.co.jp>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Yugo NAGATA <nagata@sraoss.co.jp>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Yugo NAGATA <nagata@sraoss.co.jp>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Israel Barth Rubio <barthisrael@gmail.com>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane <tgl@sss.pgh.pa.us>
Peter Eisentraut  writes:
> This has broken the following use:

> parse: create temporary table t1 (a int) on commit drop
> bind
> execute
> parse: analyze t1
> bind
> execute
> parse: select * from t1
> bind
> execute
> sync

> I think the behavior of IsInTransactionBlock() needs to be further 
> refined to support this.

Hmm.  Maybe the right way to think about this is "if we have completed an
EXECUTE, and not yet received a following SYNC, then report that we are in
a transaction block"?  But I'm not sure if that breaks any other cases.

			regards, tom lane


В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
От: Tom Lane
Дата:
FAQ