[postgis-devel] postgis-1.1.2: a few improvements

alex bodnaru alexbodn at 012.net.il
Fri May 19 16:37:47 PDT 2006


hi friends,

i have included the postgis topology functionality in the debian postgis
package, and i'd like to add a few suggestions:

1. for files in topology/test, please apply the attached patches.
   it's about a few missed points in the makefile, and with working in
an environment without oids.

2. the topology test fails under postgresql-7.4 wich refuses to have
composite types as fields.

psql:load_topology.sql:214: ERROR:  column "feature" has composite type
topology.topogeometry
CONTEXT:  PL/pgSQL function "addtopogeometrycolumn" line 91 at execute
statement

it would be possible to save topogeometries as records in a table,
related 1:1 to the one that currently caries the extra column. else,
postgresql 7.4 installations should not receive topology.sql.

3. PGFELIBS, (comming from pg_config --libs) holds all the libs used
when building postgresql. i have substituted $(PGFELIBS) with -lpq (this
exist only in loader/Makefile, for building pgsql2shp), and this seems
to work as well.

the debian packages for postgis are been constantly uploaded to debian
gis, and i hope we'll soon be present in main debian.

best regards,

alex

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Makefile.diff
Type: text/x-patch
Size: 872 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20060520/4016f9ec/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: load_topology.sql.diff
Type: text/x-patch
Size: 633 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20060520/4016f9ec/attachment-0001.bin>


More information about the postgis-devel mailing list