[postgis-users] RE RE : RE RE : using WKT Raster

[Steve.Toutant at inspq.qc.ca]

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 <Pierre.Racine at sbf.ulaval.ca>@postgis.refractions.net 
Envoyé par : postgis-users-bounces at postgis.refractions.net
15/01/2010 01:15 PM
Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>


A
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
cc
"postgis-users-bounces at postgis.refractions.net" 
<postgis-users-bounces at postgis.refractions.net>
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 : postgis-users-bounces at postgis.refractions.net 
[postgis-users-bounces at postgis.refractions.net] de la part de 
Steve.Toutant at inspq.qc.ca [Steve.Toutant at inspq.qc.ca]
Date d'envoi : 15 janvier 2010 12:58
À : PostGIS Users Discussion
Cc : postgis-users-bounces at postgis.refractions.net
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 <Pierre.Racine at sbf.ulaval.ca>@postgis.refractions.net
Envoyé par : postgis-users-bounces at postgis.refractions.net

15/01/2010 04:14 AM
Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>




A
        PostGIS Users Discussion <postgis-users at postgis.refractions.net>
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
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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100115/7c8ba55a/attachment.html>