PreventTransactionChain cannot prevent single query transaction.

Started by Jacky Lengalmost 18 years ago2 messagesbugs
Jump to latest
#1Jacky Leng
lengjianquan@163.com

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jacky Leng (#1)
Re: PreventTransactionChain cannot prevent single query transaction.

"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