[postgis-users] createlang plpqsql fails

Obe, Regina DND\MIS robe.dnd at ci.boston.ma.us
Mon Apr 7 09:18:20 PDT 2003


It sounds like your libpostgis.so.0 can't be found or is not compiled
correctly.

If you are running on Cygwin - that should actually be pointing to
postgis.dll, I think you can manually change it in the postgis.sql script
and rerun.

If you are running on Linux/Unix - I think it should be libpostgis.so, but
not sure so someone else can verify that.



-----Original Message-----
From: Benjamin Thelen [mailto:benjamin.thelen at ccgis.de]
Sent: Monday, April 07, 2003 11:58 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] createlang plpqsql fails


Hi,

after compiling the next step is "# createlang plpgsql [yourdatabase]".
Somehow strange, after executing this command, no message ist prompted
(operation successful or something like that). So, I am not sure whether
this step was successful. After that "# psql -d [yourdatabase] -f
postgis.sql" has to be executed. Obviously PL/PgSQL is installed, but after
that a big error message can be seen (see output below).
At the beginning of postgis.sql it is said, that if PL/PgSQL is installed
that this will be prompted, but if not I get a big error message.
So, well, I get both. :-).

If i try to execute this command again, "createlang" replies that plpgsql is
already installed in that database. So assume the previous operation was
successful.

But When I try this
CREATE TABLE gtest ( ID int4, NAME varchar(20) );
SELECT AddGeometryColumn('dbname','gtest','geom',-1,'LINESTRING',2);

I receive the error message, that Function addgeometrycolumn does not exist,
what according to the postgis manual means that the PostGIS functions and
objects have not been loaded into this database.

I am stuck. What's wrong here? Can anybody help?
I'll supply any further information if needed!


Thanks in advance,
Benjamin



> psql -d mydb -f postgis.sql
BEGIN
        message
------------------------
 PL/PgSQL is installed.
(1 row)

psql:postgis.sql:18: NOTICE:  ProcedureCreate: type histogram2d is not yet
defin
ed
psql:postgis.sql:18: ERROR:  stat failed on file '$libdir/libpostgis.so.0':
No s
uch file or directory
psql:postgis.sql:23: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:31: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:39: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:44: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:51: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:59: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:64: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:71: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:79: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:84: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:91: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:99: ERROR:  current transaction is aborted, queries ignored
unt
il end of transaction block
psql:postgis.sql:104: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:112: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:120: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:125: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:133: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:142: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:154: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:174: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:181: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:182: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:183: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:190: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:203: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:211: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:218: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:285: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:368: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:387: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:408: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:414: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:428: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:433: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:438: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:443: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:448: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:453: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:458: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:463: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:468: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:473: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:478: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:483: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:488: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:493: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:502: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:507: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:512: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:526: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:531: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:536: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:541: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:546: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:551: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:556: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:561: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:566: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:571: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:576: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:581: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:586: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:591: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:596: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:601: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:606: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:611: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:616: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:621: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:626: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:631: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:636: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:641: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:646: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:651: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:656: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:661: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:670: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:675: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:680: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:689: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:694: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:699: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:704: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:709: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:714: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:719: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:724: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:729: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:734: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:739: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:748: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:753: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:758: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:763: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:768: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:773: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:778: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:787: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:793: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:798: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:804: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:813: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:818: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:823: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:828: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:833: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:838: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:843: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:848: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:857: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:862: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:867: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:876: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:881: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:890: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:900: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:906: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:912: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:918: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:924: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:930: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:936: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:942: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:948: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:954: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:960: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:967: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:968: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:969: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:970: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:971: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:972: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:973: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:988: ERROR:  current transaction is aborted, queries
ignored un
til end of transaction block
psql:postgis.sql:1007: ERROR:  current transaction is aborted, queries
ignored u
ntil end of transaction block
psql:postgis.sql:1017: ERROR:  current transaction is aborted, queries
ignored u
ntil end of transaction block
psql:postgis.sql:1026: ERROR:  current transaction is aborted, queries
ignored u
ntil end of transaction block
psql:postgis.sql:1035: ERROR:  current transaction is aborted, queries
ignored u
ntil end of transaction block
psql:postgis.sql:1044: ERROR:  current transaction is aborted, queries
ignored u
ntil end of transaction block
psql:postgis.sql:1049: ERROR:  current transaction is aborted, queries
ignored u
ntil end of transaction block
psql:postgis.sql:1058: ERROR:  current transaction is aborted, queries
ignored u
ntil end of transaction block
psql:postgis.sql:1063: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1068: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1073: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1078: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1083: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1088: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1097: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1102: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1107: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1129: ERROR:  current transaction is aborted, queries
ignored u   ntil end of transaction block
psql:postgis.sql:1133: ERROR:  current transaction is aborted, queries
ignored u   ntil 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