Using bdr replication with SERIAL pseudo-type. - Mailing list pgsql-general

From Benjamin Scherrey
Subject Using bdr replication with SERIAL pseudo-type.
Date
Msg-id CACo3ShjNfukMt1K0VAr0F0ZSFguf9s=8pyLMKOHuZKn+248ffg@mail.gmail.com
Whole thread Raw
List pgsql-general
We're trying to use bdr replication with DJango. Django's default primary keys are SERIAL columns which is a pseudo type that uses global sequences ( http://www.postgresql.org/docs/devel/static/datatype-numeric.html#DATATYPE-SERIAL ). BDR requires a global sequence to be defined using an explicit USING bdr command ( https://wiki.postgresql.org/wiki/BDR_Global_Sequences ). Is there some way to globally cause the SERIAL pseudo-type to create global sequences via bdr for the entire database? Can SERIAL be redeclared inside a database so its sequences will be created using bdr?

thanx,

  -- Ben Scherrey

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Modeling Friendship Relationships
Next
From: "Nestor A. Diaz"
Date:
Subject: Re: Autovacuum on partitioned tables in version 9.1