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

Reply via email to