[HACKERS] BDR Multiple database

2015-02-26 Thread Jirayut Nimsaeng
Hi all, I'm using PostgreSQL BDR 9.4.1 to test BDR capability right now $ psql --version psql (PostgreSQL) 9.4.1 We want to use BDR with multiple database but now all the document didn't show any example how to config BDR with multiple database. We've tried with many combination as below but sti

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 wrote: > On 24 November 2014 at 09:55, Jirayut Nimsa

[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,