[Pgpool-general] pgpool-II 2.2 beta2 released

[Łukasz Jagiełło]

W dniu 9 lutego 2009 11:21 użytkownik Tatsuo Ishii <ishii at sraoss.co.jp> napisał:
> Oops. CREATE DATABASE does not seem to be transaction safe. Please
> apply included patches.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
> Index: pool_process_query.c
> ===================================================================
> RCS file: /cvsroot/pgpool/pgpool-II/pool_process_query.c,v
> retrieving revision 1.137
> diff -c -r1.137 pool_process_query.c
> *** pool_process_query.c        6 Feb 2009 15:30:51 -0000       1.137
> --- pool_process_query.c        9 Feb 2009 10:20:06 -0000
> ***************
> *** 3910,3916 ****
>                T_ViewStmt,             /* CREATE VIEW */
>                T_LoadStmt,
>                T_CreateDomainStmt,
> !               T_CreatedbStmt,
>                T_DropdbStmt,
>                T_CreateSeqStmt,
>                T_AlterSeqStmt,
> --- 3910,3918 ----
>                T_ViewStmt,             /* CREATE VIEW */
>                T_LoadStmt,
>                T_CreateDomainStmt,
> !               /*
> !                 T_CreatedbStmt,       CREATE DATABASE cannot execute inside a transaction block
> !               */
>                T_DropdbStmt,
>                T_CreateSeqStmt,
>                T_AlterSeqStmt,
>
>

#v+
postgres=# CREATE DATABASE test WITH TEMPLATE = template1 ENCODING = 'UTF8';
CREATE DATABASE
postgres=# drop database test;
2009-02-09 11:00:04 LOG:   pid 5306: SimpleQuery: received SET
TRANSACTION ISOLATION LEVEL must be called before any query error.
query: drop database test;
ERROR:  DROP DATABASE cannot run inside a transaction block
postgres=# \q
#v-

Guess 'DROP DATABASE' need to be exclude also.

-- 
Łukasz Jagiełło
G-Forces Web Management Polska

T: +44 (0) 845 055 9040
F: +44 (0) 845 055 9038
E: lukasz.jagiello at gforces.pl
W: www.gforces.co.uk

This e-mail is confidential and intended solely for the use of the
individual to whom it is addressed. If you are not the intended
recipient, please notify the sender immediately. Do not disclose the
contents of this e-mail to any other person, use it for any purpose,
print, copy, store, or distribute it. This e-mail should then be
destroyed. Any views expressed in this message are those of the
individual sender except where the sender specifically states them to
be the views of G-Forces Web Management Ltd. Registered Office: 4 & 5
Kings Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered
Company No. 3863609. VAT Registration No. 7250 384 50