Re: [GENERAL] ALTER TABLE to ADD BDR global sequence

2015-01-07 Thread Craig Ringer
On 01/07/2015 11:57 PM, John Casey wrote: > I have been thinking about an alternate means of implementing global > sequences that I feel would simplify things. > > Rather than chunking out blocks, set an increment value for each sequence > equal to the number of nodes in the "cluster". Each nod

Re: [GENERAL] ALTER TABLE to ADD BDR global sequence

2015-01-07 Thread John Casey
I have been thinking about an alternate means of implementing global sequences that I feel would simplify things. Rather than chunking out blocks, set an increment value for each sequence equal to the number of nodes in the "cluster". Each node has an offset. So, if you have 10 nodes, mode 1 h

Re: [GENERAL] ALTER TABLE to ADD BDR global sequence

2015-01-07 Thread Craig Ringer
On 01/04/2015 12:33 AM, John Casey wrote: > While attempting to alter a table to add a global sequence as a primary > key using the following commands: > > CREATE SEQUENCE my_table_id_seq USING bdr; > > ALTER TABLE my_table > > ADD COLUMN id integer PRIMARY KEY NOT NULL DEFAULT > nextval('my_tab

[GENERAL] ALTER TABLE to ADD BDR global sequence

2015-01-05 Thread John Casey
While attempting to alter a table to add a global sequence as a primary key using the following commands: CREATE SEQUENCE my_table_id_seq USING bdr; ALTER TABLE my_table ADD COLUMN id integer PRIMARY KEY NOT NULL DEFAULT nextval('my_table_id_seq'::regclass); I started to notice some issue