[postgis-users] error executing postgis.sql
Heiko.Kehlenbrink at vermes.fh-oldenburg.de
Heiko.Kehlenbrink at vermes.fh-oldenburg.de
Tue Mar 18 08:31:04 PST 2003
hi all,
try to install postgis on a fresh suse 8.1 and got this error message executing postgis.sql:
(i cut a lot of "create functions" rows out)
BEGIN
message
----------------------
plpgsql is installed
(1 row)
CREATE FUNCTION
psql:postgis.sql:29: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'spatial_ref_sys_pkey' for table 'spatial_ref_sys'
CREATE TABLE
psql:postgis.sql:42: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'gc_pk' for table 'geometry_columns'
CREATE TABLE
CREATE FUNCTION
...
CREATE FUNCTION
psql:postgis.sql:218: NOTICE: ProcedureCreate: type box3d is not yet defined
CREATE FUNCTION
CREATE FUNCTION
psql:postgis.sql:228: NOTICE: ProcedureCreate: type spheroid is not yet defined
CREATE FUNCTION
CREATE FUNCTION
psql:postgis.sql:240: NOTICE: TypeCreate: changing argument type of function spheroid_in
from OPAQUE to CSTRING
psql:postgis.sql:240: NOTICE: TypeCreate: changing argument type of function spheroid_out
from OPAQUE to spheroid
psql:postgis.sql:240: NOTICE: TypeCreate: changing return type of function spheroid_out from
OPAQUE to CSTRING
CREATE TYPE
psql:postgis.sql:247: NOTICE: TypeCreate: changing argument type of function box3d_in from
OPAQUE to CSTRING
psql:postgis.sql:247: NOTICE: TypeCreate: changing argument type of function box3d_out
from OPAQUE to box3d
psql:postgis.sql:247: NOTICE: TypeCreate: changing return type of function box3d_out from
OPAQUE to CSTRING
CREATE TYPE
psql:postgis.sql:252: NOTICE: ProcedureCreate: type wkb is not yet defined
CREATE FUNCTION
CREATE FUNCTION
psql:postgis.sql:268: NOTICE: TypeCreate: changing argument type of function wkb_in from
OPAQUE to CSTRING
psql:postgis.sql:268: NOTICE: TypeCreate: changing argument type of function wkb_out from
OPAQUE to wkb
psql:postgis.sql:268: NOTICE: TypeCreate: changing return type of function wkb_out from
OPAQUE to CSTRING
CREATE TYPE
psql:postgis.sql:273: NOTICE: ProcedureCreate: type chip is not yet defined
CREATE FUNCTION
CREATE FUNCTION
psql:postgis.sql:287: NOTICE: TypeCreate: changing argument type of function chip_in from
OPAQUE to CSTRING
psql:postgis.sql:287: NOTICE: TypeCreate: changing argument type of function chip_out from
OPAQUE to chip
psql:postgis.sql:287: NOTICE: TypeCreate: changing return type of function chip_out from
OPAQUE to CSTRING
CREATE TYPE
CREATE FUNCTION
...
CREATE FUNCTION
psql:postgis.sql:338: NOTICE: ProcedureCreate: type geometry is not yet defined
CREATE FUNCTION
CREATE FUNCTION
psql:postgis.sql:351: NOTICE: TypeCreate: changing argument type of function geometry_in
from OPAQUE to CSTRING
psql:postgis.sql:351: NOTICE: TypeCreate: changing argument type of function geometry_out
from OPAQUE to geometry
psql:postgis.sql:351: NOTICE: TypeCreate: changing return type of function geometry_out
from OPAQUE to CSTRING
CREATE TYPE
CREATE FUNCTION
...
CREATE FUNCTION
CREATE AGGREGATE
CREATE FUNCTION
CREATE AGGREGATE
CREATE FUNCTION
...
CREATE FUNCTION
UPDATE 1
UPDATE 1
COMMIT
BEGIN
CREATE FUNCTION
...
CREATE FUNCTION
CREATE OPERATOR
CREATE OPERATOR
psql:postgis.sql:822: ERROR: OperatorDef: function postgis_gist_sel(internal, oid, internal,
integer) does not exist
psql:postgis.sql:828: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:834: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:840: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:848: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:855: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:861: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:867: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:873: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:886: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:894: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:903: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:912: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:921: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:930: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:939: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:948: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:957: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:966: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:968: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:978: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:986: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:994: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1002: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1010: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1018: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1026: ERROR: current transaction is aborted, queries ignored until end of
transaction block
COMMIT
trying postgis 0.7.4 i got :
BEGIN
message
------------------------
PL/PgSQL is installed.
(1 row)
psql:postgis.sql:18: NOTICE: ProcedureCreate: type histogram2d is not yet defined
psql:postgis.sql:18: ERROR: stat failed on file '$libdir/libpostgis.so.0.7': No such file or
directory
psql:postgis.sql:23: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:31: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:39: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:44: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:51: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:59: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:64: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:71: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:79: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:84: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:91: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:99: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:104: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:112: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:120: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:125: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:133: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:142: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:154: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:174: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:181: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:182: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:183: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:190: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:203: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:211: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:218: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:285: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:368: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:387: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:408: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:414: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:428: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:433: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:438: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:443: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:448: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:453: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:458: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:463: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:468: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:473: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:478: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:483: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:488: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:493: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:502: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:507: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:512: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:526: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:531: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:536: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:541: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:546: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:551: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:556: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:561: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:566: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:571: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:576: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:581: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:586: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:591: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:596: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:601: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:606: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:611: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:616: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:621: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:626: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:631: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:636: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:641: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:646: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:651: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:656: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:661: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:670: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:675: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:680: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:689: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:694: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:699: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:704: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:709: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:714: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:719: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:724: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:729: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:734: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:739: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:748: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:753: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:758: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:763: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:768: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:773: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:778: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:787: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:793: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:798: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:804: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:813: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:818: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:823: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:828: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:833: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:838: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:843: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:848: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:857: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:862: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:867: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:876: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:881: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:890: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:900: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:906: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:912: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:918: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:924: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:930: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:936: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:942: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:948: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:954: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:960: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:967: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:968: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:969: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:970: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:971: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:972: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:973: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:988: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1007: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1017: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1026: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1035: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1044: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1049: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1058: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1063: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1068: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1073: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1078: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1083: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1088: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1097: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1102: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1107: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1129: ERROR: current transaction is aborted, queries ignored until end of
transaction block
psql:postgis.sql:1133: ERROR: current transaction is aborted, queries ignored until end of
transaction block
COMMIT
i`m using postgresql-7.3.2 and have altered the Makefile with USE_PROJ=1 ...
I`ve had an installation with postgres 7.2 and postgis 0.7.2 runing with no probs on suse 8.0 .
best regards
heiko kehlenbrink
More information about the postgis-users
mailing list