Thanks Jeff
But What I can't understand is:
In My first test, the "create index concurrently" works well.
In My second test, the "create index concurrently" can not work.
The difference is only on ecpg's select statement :
One use host variable of char (its value is of integer 14) in select statement,
While the other is just a simple select.
If the transaction will potentially the index, it should be same on my first test and second test.
My customer want to use PG on their 7x24 environment, while rebuilding index periodically.
If I can't do it on PG, it really confused me...
sincerely yours