[Bucardo-general] Change column type

[Greg Sabino Mullane]

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.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170214/fd752032/attachment.sig>