[Bucardo-general] Column order and foreign key

Laurent GARCES laurent.garces at l-rd.fr
Fri Mar 24 09:36:26 UTC 2017

Thanks for the answer.
Is there a way to reorder column without stopping the sync?

Laurent GARCES
LRD www.l-rd.fr
+33 (0)4 67 92 52 56

Le 23/03/2017 à 16:04, Greg Sabino Mullane a écrit :
> On Thu, Mar 23, 2017 at 10:45:40AM +0100, Laurent GARCES wrote:
> ...
>> bucardo update dbgroup shared shared_db_on_host1:source
>> shared_db_on_host2:source shared_db_on_host3:source
>> shared_db_on_host4:source
> ...
>> The database schema is the same on all host. But the fields order on host4
>> is different in some tables.
> Hmm...that's interesting. I think Bucardo may indeed choke in that case, as
> we can handle *targets* with differing column orders, but not sources.
> It's nt clear from a quick glance of the code where it is failing, as in
> theory we use a consistent $columnlist everywhere. I will dig into that.
> Your quickest workaround is to rearrange those columns though.
>>    - If yes, is there a way to force Bucardo to use column name instead of
>> just using column order?
> To be clear, it does use names.
>> - How can Bucardo can bypass the foreign key constraint?
> Bucardo sets session_replication_role, and thus ignores all triggers
> and rules (foreign keys are trigger based)

More information about the Bucardo-general mailing list