pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Ruth Melendo <rmelendo@teltronic.es>
To: 'Technical Doubts' <online.technicaldoubts@gmail.com>
To: pgsql-admin@postgresql.org
Subject: PostgreSQL with BDR. Problems when adding a sequence in a table column
Date: Mon, 2 Mar 2015 11:05:09 +0100
Message-ID: <001001d054d0$5dcbea40$1963bec0$@teltronic.es> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

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 

 <http://www.teltronic.es/; www.teltronic.es

Logo40

 

Attachments:

image001.jpg (image/jpeg, 1.6K) download
  view image

view thread (4+ messages)  latest in thread

Message-ID: <001001d054d0$5dcbea40$1963bec0$@teltronic.es>
Permalink:  ../001001d054d0$5dcbea40$1963bec0$@teltronic.es/
Also on:    postgresql.org/message-id/001001d054d0$5dcbea40$1963bec0$@teltronic.es

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rmelendo@teltronic.es, online.technicaldoubts@gmail.com
  Subject: Re: PostgreSQL with BDR. Problems when adding a sequence in a table column
  In-Reply-To: <001001d054d0$5dcbea40$1963bec0$@teltronic.es>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox