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
ajs at anvilwalrusden.com