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

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.