[Bucardo-general] modifying a table in bucardo, including PK

Greg Sabino Mullane greg at endpoint.com
Fri Apr 11 18:39:17 UTC 2014


On Fri, Apr 11, 2014 at 05:21:31PM +0000, Markova, Nina wrote:
> 
> Hi all,
> 
> I have a table TABLE1  that is being replicated in bucardo.
> I need to change the table structure -  will add more fields, some of which will be part of PK (i.e. PK will change too).
> 
> What is the best approach doing that? I wasn't able to find a blog for that.

I think the support table (delta_*) may need to be dropped/recreated as well, as 
it will have the old pk. May have to drop the function too. I will test 
it out at some point.


-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140411/1fdb09ff/attachment.sig>


More information about the Bucardo-general mailing list