Re: Schema move for opclasses, operator and conversions

--On Donnerstag, Juni 01, 2006 23:03:39 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:

> Not to be unkind,

Don't worry ;)

< but is this feature actually worth the code space?
> I can barely see a use case for relocating operators, and as for the
> other two, who's ever going to use them?
>

Well, i thought it would be useful for people which are going to reorganize
an entire database schema. Since we have schema move capabilities for
tables, functions, sequences et al., someone could then easily setup a
script to move
an entire schema to a new one.

> I understand about orthogonality and all that, but we have limited
> manpower, and every thousand lines of code costs us ongoing maintenance
> effort whether it's ever used in the field or not.
>
> What I'd love to see is a patch that *removes* a few thousand lines
> of code by finding a way to do this just once for all object types...

so something like ALTER SCHEMA schema MOVE OBJECTS newschema?
Sounds like a reasonable idea....

--
Thanks

Bernd