Re: Request for Comments: ALTER [OBJECT] SET SCHEMA

On Wed, Jun 08, 2005 at 08:25:12PM +0200, Bernd Helmle wrote:

> One issue that comes to my mind is what to do when dealing with tables that 
> have assigned triggers and sequences (serials). Do we want to move them as 
> well or leave them in the source namespace?

I'd think it's important that the ALTER TABLE leaves things just like
what you'd end up with if you created the table in the new schema in the
first place.  i.e., indexes, triggers, sequences should be moved too.

One issue to check is what happens if you move the table and trigger but
the function remains in the original namespace.  Is this a problem if
the new namespace is not in the search path?

-- 
Alvaro Herrera (<alvherre[a]surnet.cl>)
"This is a foot just waiting to be shot"                (Andrew Dunstan)