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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

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/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly