--On Donnerstag, Juni 01, 2006 23:03:39 -0400 Tom Lane <[EMAIL PROTECTED]>
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
