I have applied the patch and tested CREATE INDEX CONCURRENTLY on a staging environment with DB load and it worked fine now. thanks
Marcelo PostgreSQL DBA Linux/Solaris System Administrator On Feb 17, 2009, at 3:53 AM, Tatsuo Ishii wrote: > Fix committed. If you want try without downloading the CVS tip, please > apply included patches against RC1. > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > >> Thanks for letting me know! Will fix. >> -- >> Tatsuo Ishii >> SRA OSS, Inc. Japan >> >>> While performing some queries today it seems that CREATE INDEX >>> CONCURRENTLY is also been placed inside a transaction >>> >>> CREATE INDEX CONCURRENTLY ath_idx ON insta (ath); >>> ERROR: CREATE INDEX CONCURRENTLY cannot run inside a transaction >>> block >>> >>> Marcelo >>> PostgreSQL DBA >>> Linux/Solaris System Administrator >>> >>> On Feb 14, 2009, at 11:43 PM, Tatsuo Ishii wrote: >>> >>>> Hi, >>>> >>>> pgpool-II 2.2 RC1 is released. Changes from beta2: >>>> >>>> 2009-02-15 14:29 t-ishii >>>> >>>> * TODO: Mention that two items were resolved >>>> >>>> 2009-02-15 14:26 t-ishii >>>> >>>> * pgpool.conf.sample, doc/pgpool-en.html, doc/pgpool-ja.html: >>>> Reflect the fact that DISCARD ALL holds exclusive lock on >>>> pg_listener, thus will degrade performance. >>>> >>>> 2009-02-10 10:11 t-ishii >>>> >>>> * pool_process_query.c: Fix is_internal_transaction_needed() so >>>> that DROP DATABASE does not start internal transaction >>>> -- >>>> Tatsuo Ishii >>>> SRA OSS, Inc. Japan >>>> _______________________________________________ >>>> Pgpool-general mailing list >>>> [email protected] >>>> http://pgfoundry.org/mailman/listinfo/pgpool-general >>> >> _______________________________________________ >> Pgpool-general mailing list >> [email protected] >> http://pgfoundry.org/mailman/listinfo/pgpool-general > *** pool_process_query.c 10 Feb 2009 01:11:43 -0000 1.138 > --- pool_process_query.c 17 Feb 2009 09:46:42 -0000 > *************** > *** 3955,3961 **** > T_AlterTSConfigurationStmt > }; > > ! return bsearch(&nodeTag(node), nodemap, sizeof(nodemap)/ > sizeof(nodemap[0]), sizeof(NodeTag), compare) != NULL; > } > > POOL_STATUS start_internal_transaction(POOL_CONNECTION_POOL > *backend, Node *node) > --- 3955,3973 ---- > T_AlterTSConfigurationStmt > }; > > ! if (bsearch(&nodeTag(node), nodemap, sizeof(nodemap)/ > sizeof(nodemap[0]), sizeof(NodeTag), compare) != NULL) > ! { > ! /* > ! * chek CREATE INDEX CONCURRENTLY. If so, do not start > transaction > ! */ > ! if (IsA(node, IndexStmt)) > ! { > ! if (((IndexStmt *)node)->concurrent) > ! return false; > ! } > ! return true; > ! } > ! return false; > } > > POOL_STATUS start_internal_transaction(POOL_CONNECTION_POOL > *backend, Node *node) _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
