[postgis-tickets] [PostGIS] #4405: Index over ST_Transform(constant, SRID) breaks pg_upgrade

[PostGIS]

#4405: Index over ST_Transform(constant, SRID) breaks pg_upgrade
------------------------------------+---------------------------
  Reporter:  Algunenano             |      Owner:  Algunenano
      Type:  defect                 |     Status:  assigned
  Priority:  medium                 |  Milestone:  PostGIS 3.0.3
 Component:  build/upgrade/install  |    Version:  2.3.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Changes (by robe):

 * milestone:  PostGIS 2.5.5 => PostGIS 3.0.3


Comment:

 okay it's still an issue.

 I tried upgrading from PostGIS 2.5.5 dev PG 12 to PG 13 PostGIS 2.5.5dev
 and got same error


 {{{
 pg_restore: from TOC entry 3507; 1259 54514 INDEX idx_transf postgres
 pg_restore: error: could not execute query: ERROR:  GetProj4StringSPI:
 Cannot find SRID (4326) in spatial_ref_sys
 Command was:
 -- For binary upgrade, must preserve pg_class oids
 SELECT
 pg_catalog.binary_upgrade_set_next_index_pg_class_oid('54514'::pg_catalog.oid);

 CREATE INDEX "idx_transf" ON "public"."t95" USING "btree"
 ("public"."st_intersects"("the_geom",
 "public"."st_transform"('0101000020E61000000000000000A060C0FAEDEBC0395B4440'::"public"."geometry",
 3857)));


 }}}

 you think this is fixable.  I haven't tried Proj 6 (this was testing with
 Proj 5.2).  Seems like such a rare case and we have a workaround (just
 drop the index before you pg_upgrade)

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