[Bucardo-general] Change column type

[Laurent GARCES]

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.
>