Thanks for your answer,
We are going to change the type of the primary key from integer to
character varying (255).
I've done some test and after it we cannot insert data anymore in the
table due to bucardo.
So our only option is to stop bucardo, delete sync, update tables, and
then recreate the sync?
--
Laurent GARCES
LRD www.l-rd.fr
+33 (0)4 67 92 52 56
Le 14/02/2017 à 14:22, Greg Sabino Mullane a écrit :
On Tue, Feb 14, 2017 at 01:42:33PM +0100, Laurent GARCES wrote:
Hi,
What would be the best way to "update" a bucardo sync after changing the
type of a column in a synchronized table?
Is it possible to do it without stopping the bucardo synchronisation?
Bucardo doesn't really care about the types of the columns, as it just does
a COPY with a list of colummn names, so as long as the types are compatible,
and you are not changing the primary key type, nothing at all should need to
be done.
If the primary key itslef changes type, that's a big deal, and generally
requires
updating the internal Bucardo tables as well as a full restart.
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
