[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

Modified Files:
--------------
    pgpool-II:
        configure.in (r1.45 -> r1.46)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/configure.in?r1=1.45&r2=1.46)
        configure (r1.48 -> r1.49)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/configure?r1=1.48&r2=1.49)
        config.h.in (r1.12 -> r1.13)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/config.h.in?r1=1.12&r2=1.13)
        Makefile.am (r1.53 -> r1.54)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/Makefile.am?r1=1.53&r2=1.54)
        Makefile.in (r1.56 -> r1.57)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/Makefile.in?r1=1.56&r2=1.57)
        pool_process_query.c (r1.259 -> r1.260)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_process_query.c?r1=1.259&r2=1.260)
        pgpool.conf.sample (r1.45 -> r1.46)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pgpool.conf.sample?r1=1.45&r2=1.46)
        pgpool.conf.sample-master-slave (r1.19 -> r1.20)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pgpool.conf.sample-master-slave?r1=1.19&r2=1.20)
        pgpool.conf.sample-replication (r1.17 -> r1.18)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pgpool.conf.sample-replication?r1=1.17&r2=1.18)
        pgpool.conf.sample-stream (r1.12 -> r1.13)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pgpool.conf.sample-stream?r1=1.12&r2=1.13)
    pgpool-II/doc:
        pgpool-en.html (r1.94 -> r1.95)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/doc/pgpool-en.html?r1=1.94&r2=1.95)
        pgpool-ja.html (r1.133 -> r1.134)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/doc/pgpool-ja.html?r1=1.133&r2=1.134)

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