Search for geometry_gist_joinsel in rtpostgis.sql, replace it with postgis_gist_joinsel and rexecute the file.
Pierre ________________________________________ De : [email protected] [[email protected]] de la part de [email protected] [[email protected]] Date d'envoi : 15 janvier 2010 16:00 À : PostGIS Users Discussion Cc : [email protected] Objet : Re: [postgis-users] RE RE : RE RE : using WKT Raster Hi Regina, I'm on winXP. I use postgres 8.3 and postgis 1.4.1 I copied the dll in this folder C:\Program Files\PostgreSQL\8.3\lib In pgAdminIII I ran rtpostgis.sql and I get this error NOTICE: argument type raster is only a shell ERROR: function geometry_gist_joinsel(internal, oid, internal, smallint) does not exist ********** Error ********** ERROR: function geometry_gist_joinsel(internal, oid, internal, smallint) does not exist SQL state: 42883 Please Tell me if there is something I can do thanks Steve "Paragon Corporation" <[email protected]>@postgis.refractions.net Envoyé par : [email protected] 15/01/2010 03:32 PM Veuillez répondre à PostGIS Users Discussion <[email protected]> A "'PostGIS Users Discussion'" <[email protected]> cc Objet Re: [postgis-users] RE RE : RE RE : using WKT Raster Steve, If you are using windows, we put up a recent version yesterday for PostgreSQL 8.3 and 8.4 with a ReadMe.txt in it this time. Hopefully that will answer all your questions. http://www.postgis.org/download/windows/experimental.php Thanks, Regina ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, January 15, 2010 1:36 PM To: PostGIS Users Discussion Cc: PostGIS Users Discussion; [email protected] Subject: [postgis-users] RE RE : RE RE : using WKT Raster I was not aware that I needed to place a DLL somewhere...Perhaps it is obvious, but I'm not a programmer and I don't know much about dll and software structure. Running rtpostgis.sql and moving a dll , is that documented somewhere, maybe I missed it. Please provide a url if the doc to properly install WKT raster exist. I tried copying rtpostgis.dll into C:\Program Files\PostgreSQL\8.3\lib I don't even know if it is the right place. I ran the sql, I got this know NOTICE: type "raster" is not yet defined DETAIL: Creating a shell type definition. NOTICE: argument type raster is only a shell ERROR: function geometry_samebox(geometry, geometry) does not exist LINE 263: AS 'select geometry_samebox($1::geometry, $2::geometry)' ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ********** Error ********** ERROR: function geometry_samebox(geometry, geometry) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Character: 8525 thanks Steve Pierre Racine <[email protected]>@postgis.refractions.net Envoyé par : [email protected] 15/01/2010 01:15 PM Veuillez répondre à PostGIS Users Discussion <[email protected]> A PostGIS Users Discussion <[email protected]> cc "[email protected]" <[email protected]> Objet [postgis-users] RE : RE RE : using WKT Raster Did you first try to sort of install the WKT Raster dll at the right location? It should go in the same "lib" folder as the PostGIS one. Pierre ________________________________________ De : [email protected] [[email protected]] de la part de [email protected] [[email protected]] Date d'envoi : 15 janvier 2010 12:58 À : PostGIS Users Discussion Cc : [email protected] Objet : [postgis-users] RE RE : using WKT Raster I got this error when running the script NOTICE: type "raster" is not yet defined DETAIL: Creating a shell type definition. ERROR: could not access file "$libdir/rtpostgis": No such file or directory ********** Error ********** ERROR: could not access file "$libdir/rtpostgis": No such file or directory SQL state: 58P01 Pierre Racine <[email protected]>@postgis.refractions.net Envoyé par : [email protected] 15/01/2010 04:14 AM Veuillez répondre à PostGIS Users Discussion <[email protected]> A PostGIS Users Discussion <[email protected]> cc Objet [postgis-users] RE : using WKT Raster >How do I get the functions for postgis and how do I enable WKT Raster >extension? Steve, WKT Raster SQL functions must first be loaded in the database. You must execute the rtpostgis.sql file located in the share/contrib folder. If you are using pgAdmin III, just open the SQL file and execute it. This is why it could not find the addrastercolumn function... Hope this help, Pierre _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
