[PostGIS] #5802: CREATE OPERATOR = not marked as changed

[PostGIS]

#5802: CREATE OPERATOR = not marked as changed
---------------------+---------------------------
 Reporter:  robe     |      Owner:  robe
     Type:  defect   |     Status:  assigned
 Priority:  medium   |  Milestone:  PostGIS 3.5.1
Component:  postgis  |    Version:  3.5.x
 Keywords:           |
---------------------+---------------------------
 I just noticed when comparing 3.4 with 3.5, that the

 OPERATOR = was changed in 3.5.0, but this was not marked as such, so
 migrations from 3.4 to 3.5 will not pick this up.

 e.g.

 3.4 has signature:


 {{{
 CREATE OPERATOR = (
         LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_eq,
         COMMUTATOR = '=', -- we might implement a faster negator here
         RESTRICT = contsel, JOIN = contjoinsel, HASHES, MERGES
 );
 }}}


 and 3.5 has signature and addition of <> operator


 {{{
 CREATE OPERATOR = (
         LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_eq,
         COMMUTATOR = '=', NEGATOR = '<>',
         RESTRICT = contsel, JOIN = contjoinsel, HASHES, MERGES
 );

 -- Availability: 3.5.0
 CREATE OPERATOR <> (
         LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_neq,
         COMMUTATOR = '<>', NEGATOR = '=',
         RESTRICT = contsel, JOIN = contjoinsel, HASHES, MERGES
 );
 }}}


 I have to confirm that our upgrade machinery is smart enough to handle
 this too if we mark it as changed in 3.5
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5802>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.