Re: Renaming tables to other schemas - Mailing list pgsql-hackers

From Robert Treat
Subject Re: Renaming tables to other schemas
Date
Msg-id 200402201013.01266.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Renaming tables to other schemas  (Rod Taylor <rbt@rbt.ca>)
Responses Re: Renaming tables to other schemas  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
On Sunday 15 February 2004 07:53, Rod Taylor wrote:
> On Sun, 2004-02-15 at 01:34, Neil Conway wrote:
> > ziga@ljudmila.org writes:
> > > The capability to move objects to other schemas would be quite
> > > useful.
> >
> > I agree. It's not utterly-trivial to implement (for one thing, you
> > need to move any dependant objects like indexes to the new schema),
> > but some form of this functionality would be a useful thing to add,
> > IMHO.
>
> It's not that hard to do either (I've done about 100 tables by hand at
> this point).
>
> Anyway, this should be supported by all RENAME commands, not just ALTER
> TABLE.

Rod, can you lay out some psdueo code / logic involved in the process?  I'm 
guessing you lock the entry in pg_class, you up dependent objects, lock them, 
update them all... is there more to it?

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


pgsql-hackers by date:

Previous
From: "Thomas Hallgren"
Date:
Subject: Re: Advice regarding configuration parameters
Next
From: Rod Taylor
Date:
Subject: Re: Renaming tables to other schemas