[Postgres-xl-general] Reload Replicated Table?

Aaron Jackson 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...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140919/7a38d0e9/attachment.htm>

More information about the postgres-xl-general mailing list