Thread: PreventTransactionChain cannot prevent single query transaction.

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.

"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