[Postgres-xl-general] Reload Replicated Table?
ajackson at revionics.com
Thu Sep 18 23:56:49 PDT 2014
Have a table of 28K items - so really not much - table is distributed by replication. Added 3 data nodes and tried to redistribute the data to these new nodes. Ended up with table truncation errors due to foreign key constraints. My guess here is that a table managed by replication doesn't need to truncate at either the source or destination...
ERROR: cannot truncate a table referenced in a foreign key constraint
My options appear to be
1. reload the table and dependencies
2. drop the constraint and redistribute then reset the constraint
Any other options?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgres-xl-general