Mon Dec 8 12:47:34 PST 2008
- Previous message: [Slony1-general] Best Practices for renaming tables in Slony?
- Next message: [Slony1-general] Re: Best Practices for renaming tables in Slony?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Thu, 04 Dec 2008 17:36:16 -0500 cbbrowne <cbbrowne at ca.afilias.info> wrote: > Mark Stosberg wrote: > > Hello, > > > > I haven't found this answer in the documentation, so I'm hoping someone here > > can point me in the right direction. > > > > What's the best practice for renaming tables managed by slony? Is it treated > > as removing and re-adding a new table, or is there a shortcut? > > > > I've got a project where I need to rename 30 columns, 2 sequences, 11 tables > > and 7 views... > > > > We are still using Slony 1.2.x. > > > > Thanks for the help! > > > I have handled this in the past via running a DDL script via "EXECUTE > SCRIPT" that did an "alter table ... rename to ...". Thanks very much Christopher. That's just the kind answer I was looking for. Mark
- Previous message: [Slony1-general] Best Practices for renaming tables in Slony?
- Next message: [Slony1-general] Re: Best Practices for renaming tables in Slony?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list