[postgis-users] createlang plpqsql fails
Benjamin Thelen
benjamin.thelen at ccgis.de
Mon Apr 7 08:57:39 PDT 2003
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
More information about the postgis-users
mailing list