[postgis-users] 0.8.1 postgis.sql execution failure
Jeff Baughman
jlbaugh at pacbell.net
Tue Feb 10 23:17:43 PST 2004
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.
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
More information about the postgis-users
mailing list