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

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Steve.Toutant at inspq.qc.ca
Sent: Friday, January 15, 2010 1:36 PM
To: PostGIS Users Discussion
Cc: PostGIS Users Discussion; postgis-users-bounces at postgis.refractions.net
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 <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/23a5cfd4/attachment.html>