Re: Table Partitioning: Sequence jump issue 10 in 10 with serialdatatype - Mailing list pgsql-general

Sorry, your right! The example is:

CREATE TABLE customers (
    id serial PRIMARY KEY,
    name TEXT,
    other_data TEXT
);

CREATE TABLE customers_part1(
 CHECK (id<10000)
)INHERITS (customers);

CREATE TABLE customers_part2(
 CHECK (id>=10000 AND id<20000)
)INHERITS (customers);

CREATE OR REPLACE RULE inserts_customer_part1
AS ON INSERT TO customers
WHERE new.id < 10000
DO INSTEAD  INSERT INTO customers_part1 SELECT NEW.*;

CREATE OR REPLACE RULE inserts_customer_part2
AS ON INSERT TO customers
WHERE new.id >= 10000 AND new.id < 20000
DO INSTEAD  INSERT INTO customers_part2 SELECT NEW.*;

INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');
INSERT INTO customers (name, other_data) VALUES ('XXXXXXx','YYYYYYYYYY');


dd=# SELECT * FROM customers;
 id |  name   | other_data
----+---------+------------
  3 | XXXXXXx | YYYYYYYYYY
  7 | XXXXXXx | YYYYYYYYYY
 11 | XXXXXXx | YYYYYYYYYY
 15 | XXXXXXx | YYYYYYYYYY
 19 | XXXXXXx | YYYYYYYYYY
 23 | XXXXXXx | YYYYYYYYYY
(6 rows)




-----
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html