[Pgpool-general] pgpool-II 2.2 RC1 released

[Tatsuo Ishii]

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
> > > Pgpool-general at pgfoundry.org
> > > http://pgfoundry.org/mailman/listinfo/pgpool-general
> > 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
-------------- next part --------------
*** 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)