[postgis-users] 0.8.1 postgis.sql execution failure

strk strk at keybit.net
Wed Feb 11 06:01:34 PST 2004 

jlbaugh wrote:
> Hi,
> 
> Installed postgis 0.8.1 into contrib subdirectory of postgresql-7.4.1 source tree.
> 
> USE_PROJ=0, USE_GEOS=0 and USE_STATS=0 in the Makefile.  Make and Make Install okfine.
> 
> Upon execution of postgis.sql, see.. 
> could not find function "centroid" below.

It seems to be a missing 'make clean'.
The 'centroid' function is defined in both postgis_fn.c and postgis_geos.c
Preprocessor directives make one or the other exist (ifdef/ndef USE_GEOS)
so you should always have it defined. In your case it should be defined 
in postgis_fn.c.

--strk;

> 
> Thanks for any help you can provide.
> 
> 
> [postgres at HPPAV postgis-0.8.1]$
> /usr/local/pgsql/bin/createlang plpgsql VericomTechGIS
> [postgres at HPPAV postgis-0.8.1]$
> /usr/local/pgsql/bin/psql -f postgis.sql -d
> VericomTechGIS
> BEGIN
>        message
> ------------------------
> PL/PgSQL is installed.
> (1 row)
> 
> psql:postgis.sql:44: NOTICE:  type "histogram2d" is
> not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:postgis.sql:49: NOTICE:  argument type
> histogram2d is only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:postgis.sql:65: NOTICE:  type "box3d" is not yet
> defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:postgis.sql:70: NOTICE:  argument type box3d is
> only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:postgis.sql:85: NOTICE:  type "spheroid" is not
> yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:postgis.sql:90: NOTICE:  argument type spheroid
> is only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:postgis.sql:105: NOTICE:  type "wkb" is not yet
> defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:postgis.sql:110: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:115: NOTICE:  return type wkb is only
> a shell
> CREATE FUNCTION
> psql:postgis.sql:124: NOTICE:  type "chip" is not yet
> defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:postgis.sql:129: NOTICE:  argument type chip is
> only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:postgis.sql:145: NOTICE:  type "geometry" is not
> yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:postgis.sql:150: NOTICE:  argument type geometry
> is only a shell
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> psql:postgis.sql:260: NOTICE:  CREATE TABLE / PRIMARY
> KEY will create implicit index "spatial_ref_sys_pkey"
> for table "spatial_ref_sys"
> CREATE TABLE
> psql:postgis.sql:280: NOTICE:  CREATE TABLE / PRIMARY
> KEY will create implicit index "geometry_columns_pk"
> for table "geometry_columns"
> CREATE TABLE
> UPDATE 1
> UPDATE 1
> UPDATE 1
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> psql:postgis.sql:473: NOTICE:  return type wkb is only
> a shell
> CREATE FUNCTION
> psql:postgis.sql:478: NOTICE:  return type wkb is only
> a shell
> CREATE FUNCTION
> psql:postgis.sql:483: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:488: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:493: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:498: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:503: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:508: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:513: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:518: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:524: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:529: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:534: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:539: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:544: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:549: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:555: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:560: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:566: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:571: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:576: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:581: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:587: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:592: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:597: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:602: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:607: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:612: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:619: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> psql:postgis.sql:624: NOTICE:  argument type wkb is
> only a shell
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> psql:postgis.sql:1004: ERROR:  could not find function
> "centroid" in file
> "/usr/local/pgsql/lib/libpostgis.so.0.8"
> psql:postgis.sql:1009: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1014: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1024: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1029: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1034: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1039: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1044: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1049: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1054: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1063: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1068: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1074: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1079: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1085: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1090: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1097: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1107: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1112: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1117: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1122: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1127: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1132: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1137: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1142: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1151: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1156: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1161: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1166: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1171: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1176: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1185: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1190: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1199: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1209: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1215: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1221: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1227: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1233: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1239: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1245: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1251: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1261: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1267: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1273: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1279: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1284: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1294: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1299: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1304: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1310: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1315: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1320: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1326: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1332: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1338: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1343: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1350: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1356: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1361: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1366: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1371: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1376: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1381: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1386: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1391: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1396: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1401: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1406: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1416: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1481: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1487: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1488: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1489: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1490: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1491: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1492: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1493: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1494: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1509: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1528: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1538: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1547: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1556: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1565: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1570: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1579: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1584: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1589: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1594: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1599: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1604: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1609: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1618: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1623: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1628: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1650: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1654: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1663: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1707: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1815: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1826: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> psql:postgis.sql:1913: ERROR:  current transaction is
> aborted, commands ignored until end of transaction
> block
> COMMIT
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list