[HACKERS] BDR duplicate key value violates unique constraint error

2014-11-24 Thread Jirayut Nimsaeng
Hi, I'm using PostgreSQL BDR 9.4beta2 to test BDR capability right now. $ psql --version psql (PostgreSQL) 9.4beta2 I used database name bdrdemo for BDR then I've created tables with this DDL CREATE TABLE DEPARTMENT( ID SERIAL PRIMARY KEY NOT NULL, DEPT CHAR(50) NOT NULL,

Re: [HACKERS] BDR duplicate key value violates unique constraint error

2014-11-24 Thread Thom Brown
On 24 November 2014 at 09:55, Jirayut Nimsaeng jira...@proteus-tech.com wrote: Hi, I'm using PostgreSQL BDR 9.4beta2 to test BDR capability right now. $ psql --version psql (PostgreSQL) 9.4beta2 I used database name bdrdemo for BDR then I've created tables with this DDL CREATE TABLE

Re: [HACKERS] BDR duplicate key value violates unique constraint error

2014-11-24 Thread Jirayut Nimsaeng
NVM. I asked people in IRC and it turns out that after I used ALTER DATABASE bdrdemo SET default_sequenceam=department_id_seq; command I have to exit from psql session first and it works again :) On Mon, Nov 24, 2014 at 6:29 PM, Thom Brown t...@linux.com wrote: On 24 November 2014 at 09:55,