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
[email protected]
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
