Thread: Using bdr replication with SERIAL pseudo-type.

Using bdr replication with SERIAL pseudo-type.

From
Benjamin Scherrey
Date:
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