Contents

-- Create lock control table for tables using sequence in native replication mode.

DROP TABLE pgpool_catalog.insert_lock;

CREATE SCHEMA pgpool_catalog;
CREATE TABLE pgpool_catalog.insert_lock(reloid OID PRIMARY KEY);
 
-- this row is used as the row lock target when pgpool inserts new oid
INSERT INTO pgpool_catalog.insert_lock VALUES (0);

-- allow "SELECT ... FOR UPDATE" and "INSERT ..." to all roles
GRANT USAGE ON SCHEMA pgpool_catalog TO PUBLIC;
GRANT SELECT ON pgpool_catalog.insert_lock TO PUBLIC;
GRANT UPDATE ON pgpool_catalog.insert_lock TO PUBLIC;
GRANT INSERT ON pgpool_catalog.insert_lock TO PUBLIC;

Version data entries

12 entries across 12 versions & 1 rubygems

Version	Path
prestogres-0.4.8	pgpool2/sql/insert_lock.sql
prestogres-0.4.7	pgpool2/sql/insert_lock.sql
prestogres-0.4.6	pgpool2/sql/insert_lock.sql
prestogres-0.4.5	pgpool2/sql/insert_lock.sql
prestogres-0.4.4	pgpool2/sql/insert_lock.sql
prestogres-0.4.3	pgpool2/sql/insert_lock.sql
prestogres-0.4.2	pgpool2/sql/insert_lock.sql
prestogres-0.4.1	pgpool2/sql/insert_lock.sql
prestogres-0.4.0	pgpool2/sql/insert_lock.sql
prestogres-0.3.0	pgpool2/sql/insert_lock.sql
prestogres-0.2.0	pgpool2/sql/insert_lock.sql
prestogres-0.1.0	pgpool2/sql/insert_lock.sql