Re: PostgreSQL with BDR. Problems when adding a sequence in a table column

Hi Ruth,

You need to create the sequence first USING BDR then alter the table
setting DEFAULT nextval('..._seq').

CREATE SEQUENCE my_id_seq USING BDR;

Make sure your table has a primary key for BDR.

HTH.
-Greg

On Mon, Mar 2, 2015 at 3:05 AM, Ruth Melendo <rmelendo(at)teltronic(dot)es> wrote:

> Hi,
>
>
>
> How can I fix this in a database with BDR?
>
>
>
> ... ALTER TABLE … ADD COLUMN …. DEFAULT may only affect UNLOGGED or
> TEMPORARY
>
> tables when BDR is active; test_table is a regular table
>
>
>
> This error happens when trying to add a column to a table with a sequence.
>
>
>
> Thanks in advance!
>
>
>
> *Ruth Patricia Melendo Ventura*
>
> *Software Engineer*
>
> TELTRONIC, S.A.U.
>
> T: +34 976 465656 Ext. 179
>
> F: +34 976 465722
>
> www.teltronic.es
>
> [image: Logo40]
>
>
>