[postgis-tickets] [PostGIS] #4553: tickets.sql fail with --schema postgis (UpdateGeometrySRID?)

PostGIS trac at osgeo.org
Fri Oct 18 08:27:14 PDT 2019


#4553: tickets.sql fail with --schema postgis (UpdateGeometrySRID?)
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.0.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by strk):

 Here's the problem:
 {{{
 postgis_reg=# select * from postgis.geometry_columns;
  f_table_catalog | f_table_schema | f_table_name | f_geometry_column |
 coord_dimension | srid | type
 -----------------+----------------+--------------+-------------------+-----------------+------+-------
  postgis_reg     | public         | road_pg      | roads_geom        |
 2 | 3395 | POINT
 (1 row)

 postgis_reg=# SELECT '#1596.2', postgis.UpdateGeometrySRID(
 '','','road_pg','roads_geom', 330000);
 ERROR:  column not found in geometry_columns table
 CONTEXT:  PL/pgSQL function updategeometrysrid(character varying,character
 varying,character varying,character varying,integer) line 35 at RAISE
 }}}

 The search_path in the session issuing the above is just "public".

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


More information about the postgis-tickets mailing list