Using bdr replication with SERIAL pseudo-type.

From: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Using bdr replication with SERIAL pseudo-type.
Date: 2014-11-12 12:02:16
Message-ID: CACo3ShjNfukMt1K0VAr0F0ZSFguf9s=8pyLMKOHuZKn+248ffg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
http://proteus-tech.com

Browse pgsql-general by date

  From Date Subject
Next Message Nestor A. Diaz 2014-11-12 12:56:02 Re: Autovacuum on partitioned tables in version 9.1
Previous Message John R Pierce 2014-11-12 01:37:36 Re: Modeling Friendship Relationships