[postgis-tickets] [PostGIS] #3956: Upgrade does not upgrade geog_brin_inclusion_add_value function to use the updated module

[PostGIS]

#3956: Upgrade does not upgrade geog_brin_inclusion_add_value function to use the
updated module
-----------------------+---------------------------
  Reporter:  keiko713  |      Owner:  robe
      Type:  defect    |     Status:  reopened
  Priority:  medium    |  Milestone:  PostGIS 2.4.3
 Component:  postgis   |    Version:  2.4.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by robe):

 keiko713 can you send me the file postgis-2.3.3-2.4.2.sql that got
 packaged with your postgresql-9.6-postgis-2.4-scripts.

 I tested with my windows scripts, and I can't replicate this.

 I also looked at my postgis-2.3.3--2.4.2.sql and I see this line


 {{{
 -- Availability: 2.3.0
 CREATE OR REPLACE FUNCTION geog_brin_inclusion_add_value(internal,
 internal, internal, internal) RETURNS boolean
         AS '$libdir/postgis-2.4','geog_brin_inclusion_add_value'
         LANGUAGE 'c';

 }}}


 There is no IF DEF in the script.  The function gets reinstalled
 regardless what version of PostGIS you are coming from UNLESS you are
 running with PostGIS scripts generated from PostgreSQL < 9.5.

 I suspect this is a packaging bug and not a PostGIS bug, but want to
 verify my suspicion.  It's possible debian folks shipped the wrong scripts
 thinking that all postgis-2.3.3-2.4.3.sql are made the same and they are
 not.

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