Thread: Schema move for opclasses, operator and conversions

Please find attached a patch that allows operator classes, operator and
conversions
to be moved between schemas. Regression and documentation patch included.

[ sorry if that occurs twice, but my first attempt used the wrong identity
:( ]

--
  Thanks

                    Bernd

Bernd Helmle <mailings@oopsware.de> writes:
> Please find attached a patch that allows operator classes, operator and
> conversions
> to be moved between schemas. Regression and documentation patch included.

Not to be unkind, 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?

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...

            regards, tom lane

--On Donnerstag, Juni 01, 2006 23:03:39 -0400 Tom Lane <tgl@sss.pgh.pa.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

Am Freitag, 2. Juni 2006 10:11 schrieb Bernd Helmle:
> so something like ALTER SCHEMA schema MOVE OBJECTS newschema?
> Sounds like a reasonable idea....

I don't think the syntax should be altered.  But a way to factor all these
common activities like moving, renaming, owner-altering for N classes of
objects would be really appreciated.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/