[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