Request for Comments: ALTER [OBJECT] SET SCHEMA

I've took a look at the TODO item

                Allow objects to be moved to different schemas

I've done some code so far which implements the syntax

                ALTER [OBJECT] name SET SCHEMA name

where OBJECT currently is

                SEQUENCE
                TABLE
                FUNCTION
                DOMAIN
                TYPE

Missing are (and i'm planning to add support for this):

                AGGREGATE
                OPERATOR
                OPERATOR CLASS
                CONVERSION

You can find a preliminary patch attached to this posting and i'm looking
for comments, critics and perhaps some proposals for improvements /
necessary changes i didn't consider yet.

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?

TIA

--

  Bernd