Обсуждение: PreventTransactionChain cannot prevent single query transaction.

Поиск
Список
Период
Сортировка

PreventTransactionChain cannot prevent single query transaction.

От
"Jacky Leng"
Дата:
So, if I execute the following sequence in a single query tansaction:

create table t;reindex database xxx;

then, t will be created successfully as long as any relation in xxx has been
reindexed.

Re: PreventTransactionChain cannot prevent single query transaction.

От
Tom Lane
Дата:
"Jacky Leng" <lengjianquan@163.com> writes:
> So, if I execute the following sequence in a single query tansaction:
> create table t;reindex database xxx;

> then, t will be created successfully as long as any relation in xxx has been
> reindexed.

This is fixed in 8.3 and up.

            regards, tom lane