Opened 13 years ago
Closed 13 years ago
#1763 closed defect (fixed)
topology on pgsql 8.4?
Reported by: | pramsey | Owned by: | strk |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 2.0.1 |
Component: | topology | Version: | 2.0.x |
Keywords: | Cc: |
Description
When trying to add polygons to a topology with PgSQL 8.4, problems:
update sheds_vict set topo = topology.toTopoGeom(geom, 'sheds'::varchar, 1);
********** Error ********** ERROR: function topogeo_addpolygon(unknown, geometry, numeric) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Context: PL/pgSQL function "totopogeom" line 128 at EXECUTE statement
Change History (3)
comment:1 by , 13 years ago
comment:3 by , 13 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
ok, I've automated a test or this with r9636 -- reopen if you still have problems
Note:
See TracTickets
for help on using tickets.
Could be a search_path issue. topology/sql/topogeometry/totopogeom.sql.in.c is missing full-qualification for the calls. Could you check if replacing the call to add "topology." prefix fixes your issue ? (I think it's a bug not to fully-qualify)
Also, check your search_path.
And check also postgis_full_version for "needs upgrade" messages. Note I'm on 8.4 so it's well tested there (beside the search_path issue).