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
