[Pgpool-general] pgpool-II 2.2 RC1 released

[Marcelo Martins]

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
>>>> 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
> *** 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)