[Pgpool-committers] pgpool - pgpool-II: Fix insert_lock so that it locks

[User Kitagawa]

Log Message:
-----------
Fix insert_lock so that it locks pgpool_catalog.insert_lock because
new PostgreSQL disallows a row lock against the sequence relation.
Add options for compatibility in configure script:
--enable-sequence-lock  insert_lock compatible with pgpool-II 3.0 series
                        (until 3.0.4)
--enable-table-lock     insert_lock compatible with pgpool-II 2.2 and 2.3
                        series

See following thread for more details:
[Pgpool-hackers] Alternative to locking sequences

Tags:
----
V3_0_STABLE

Modified Files:
--------------
    pgpool-II:
        configure.in (r1.43.2.6 -> r1.43.2.7)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/configure.in?r1=1.43.2.6&r2=1.43.2.7)
        configure (r1.46.2.6 -> r1.46.2.7)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/configure?r1=1.46.2.6&r2=1.46.2.7)
        config.h.in (r1.11.2.1 -> r1.11.2.2)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/config.h.in?r1=1.11.2.1&r2=1.11.2.2)
        Makefile.am (r1.46.2.2 -> r1.46.2.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/Makefile.am?r1=1.46.2.2&r2=1.46.2.3)
        Makefile.in (r1.49.2.2 -> r1.49.2.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/Makefile.in?r1=1.49.2.2&r2=1.49.2.3)
        pool_process_query.c (r1.249.2.9 -> r1.249.2.10)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_process_query.c?r1=1.249.2.9&r2=1.249.2.10)
        pgpool.conf.sample (r1.39.2.2 -> r1.39.2.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pgpool.conf.sample?r1=1.39.2.2&r2=1.39.2.3)
        pgpool.conf.sample-master-slave (r1.12.2.3 -> r1.12.2.4)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pgpool.conf.sample-master-slave?r1=1.12.2.3&r2=1.12.2.4)
        pgpool.conf.sample-replication (r1.11.2.2 -> r1.11.2.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pgpool.conf.sample-replication?r1=1.11.2.2&r2=1.11.2.3)
        pgpool.conf.sample-stream (r1.5.2.3 -> r1.5.2.4)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pgpool.conf.sample-stream?r1=1.5.2.3&r2=1.5.2.4)
    pgpool-II/doc:
        pgpool-en.html (r1.79.2.5 -> r1.79.2.6)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/doc/pgpool-en.html?r1=1.79.2.5&r2=1.79.2.6)
        pgpool-ja.html (r1.118.2.11 -> r1.118.2.12)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/doc/pgpool-ja.html?r1=1.118.2.11&r2=1.118.2.12)

Added Files:
-----------
    pgpool-II/sql:
        insert_lock.sql (r1.1.2.2)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/sql/insert_lock.sql?rev=1.1.2.2&content-type=text/x-cvsweb-markup)