serial.sql

CREATE TABLE example_serial(id serial, name text, created_at timestamp);
SELECT create_distributed_table('example_serial', 'id');


INSERT INTO example_serial (name, created_at) VALUES ('My test', now());
-- ERROR:  values given for the partition column must be constants or constant expressions

-- Work around:
-- 1) Create a sequence 'seq' on the coordinator node:
CREATE SEQUENCE seq;
-- 2) Calucate the nextval of the sequence in the app layer using the following SQL.
select nextval('seq');
-- 3) Place the above value in 'id_val' variable in your application and then do the insert
INSERT INTO example_serial (id, name, created_at) VALUES (id_val, 'My test', now());