[postgis-users] Problems with populate_geometry_columns in PostGIS 1.4.2

Peter Hopfgartner peter.hopfgartner at r3-gis.com
Mon May 10 07:53:42 PDT 2010


Hello

When I try to exec populate_geometry_columns(), like:

select populate_geometry_columns();

I get the following message:

ERROR:  invalid input syntax for integer: "(2::smallint"
CONTEXT:  PL/pgSQL function "populate_geometry_columns" line 75 at
assignment
PL/pgSQL function "populate_geometry_columns" line 52 at assignment

********** Error **********

ERROR: invalid input syntax for integer: "(2::smallint"
SQL state: 22P02
Context: PL/pgSQL function "populate_geometry_columns" line 75 at
assignment
PL/pgSQL function "populate_geometry_columns" line 52 at assignment


I never had this issue with PostGIS 1.4.1. Is there something I'm doing
wrong?

Regards,

Peter

OS: CentOS 5.4, 64 bit
PostgreSQL: 8.2.14
PostGIS: 1.4.2, upgraded from 1.4.1, ("POSTGIS="1.4.2"
GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September 2009" USE_STATS")



-- 
Dott. Peter Hopfgartner

R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
Email: peter.hopfgartner at r3-gis.com
Tel. : +39 0473 494949
Fax  : +39 0473 069902
www  : http://www.r3-gis.com

XING : http://www.xing.com/go/invita/8917535




More information about the postgis-users mailing list