AW: [postgis-users] createlang plpqsql fails
Benjamin Thelen
benjamin.thelen at ccgis.de
Wed Apr 9 04:23:17 PDT 2003
Yes, think, you're right. I didn't see that line!
psql:postgis.sql:18: ERROR: stat failed on file '$libdir/libpostgis.so.0':
No such file or directory
There is are a lot references in the postgis.sql file to "libpostgis.so".
For example:
CREATE FUNCTION ...
RETURNING cstring
AS '$libdir/libpostgis.so'
...
Question is, what is in the variable $libdir, obviously the wrong value and
how can I find that out and where can I change the value?!
Thanks,
Benjamin
> -----Ursprüngliche Nachricht-----
> Von: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]Im Auftrag von
> Obe, Regina DND\MIS
> Gesendet: Montag, 7. April 2003 18:18
> An: 'PostGIS Users Discussion'
> Betreff: RE: [postgis-users] createlang plpqsql fails
>
>
> 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
>
> _______________________________________________
> 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