On Thu, Dec 10, 2015 at 04:17:21PM -0500, Mike James wrote: > One of our devs wants to "archive" a table by renaming it and then > re-creating a new blank one. Something like this: > > rename "loglist" to "loglist-2015" > create loglist > > I don't need to replicate loglist-2015. What effect will this have on the > replication of the loglist table? Is there a better or best practice to do > this?
Your life will probably be better if instead the person does CREATE TABLE loglist-2015 AS SELECT * FROM loglist; TRUNCATE loglist; That assumes you're on post-8.4, but I hope you are! A -- Andrew Sullivan a...@anvilwalrusden.com _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general