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 Nimsaeng

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 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 DEPARTMENT( >I