Opened 6 years ago

Closed 6 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 Changed 6 years ago by strk

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).

comment:2 Changed 6 years ago by strk

Committed full-qualification with r9619 -- please check

comment:3 Changed 6 years ago by strk

Resolution: fixed
Status: newclosed

ok, I've automated a test or this with r9636 -- reopen if you still have problems

Note: See TracTickets for help on using tickets.