[postgis-tickets] [PostGIS] #4339: CREATE EXTENSION postgis FROM unpackaged: ERROR: operator does not exist: geometry ~~ geometry

[PostGIS]

#4339: CREATE EXTENSION postgis FROM unpackaged: ERROR:  operator does not exist:
geometry ~~ geometry
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.0.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by strk):

 I think the problem arises from the unpackaged--3.0.0.sql script doing so:
 {{{
 $postgis_proc_upgrade$
 BEGIN
   IF 300 > version_from_num FROM _postgis_upgrade_info THEN
     EXECUTE $postgis_proc_upgrade_parsed_def$ CREATE OPERATOR ~~ (
 ...
 }}}

 As I'm _already_ coming form 3.0.0 (-dev) that operator is NEVER crated.
 I guess we could tweak the block so that operators are _only_ added if
 missing (in addition to trusting the version). What do you think about
 this Regina ?

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4339#comment:3>
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.