[postgis-users] 0.8.1 postgis.sql execution failure

Jeff Baughman jlbaugh at pacbell.net
Wed Feb 11 11:30:53 PST 2004


Did make clean and then REMOVED the USE_PROJ=0 and USE_GEOS=0 from the Makefile and rebuilt okfine.

Installed ok.

> ------------Original Message------------
> > 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