[Pgpool-general] pgpool-II 3.1 released

Lonni J Friedman netllama at gmail.com
Thu Sep 8 17:04:04 UTC 2011


On Thu, Sep 8, 2011 at 5:30 AM, Toshihiro Kitagawa
<kitagawa at sraoss.co.jp> wrote:
> - Change the lock method of insert_lock. The previous insert_lock uses
>  row locking against the sequence relation, but the current one uses
>  row locking against pgpool_catalog.insert_lock table. The reason is
>  that PostgreSQL core developers decided to disallow row locking
>  against the sequence relation to avoid an internal error which it
>  leads. So creating insert_lock table in all databases which are
>  accessed via pgpool-II beforehand is required. If does not exist
>  insert_lock table, pgpool-II locks the insert target table. This
>  behavior is same as pgpool-II 2.2 and 2.3 series. If you want to use
>  insert_lock which is compatible with older releases, you can specify
>  lock method by configure options: --enable-sequence-lock,
>  --enable-table-lock(Kitagawa)

Is there a sql script somewhere for creating this table with the
correct/expected schema?


More information about the Pgpool-general mailing list