Postgres Pro
Downloads
Home   >   mailing lists

Re: PreventTransactionChain cannot prevent single query transaction. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PreventTransactionChain cannot prevent single query transaction.
Date
Msg-id 26908.1211896851@sss.pgh.pa.us
Whole thread Raw
In response to PreventTransactionChain cannot prevent single query transaction.  ("Jacky Leng" <lengjianquan@163.com>)
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: "Jacky Leng"
Date:
Subject: PreventTransactionChain cannot prevent single query transaction.
Next
From: Tom Lane
Date:
Subject: Re: BUG #4196: Backend crash possible with psql