<br><font size=2 face="sans-serif">Hi Regina,</font>
<br><font size=2 face="sans-serif">I'm on winXP. I use postgres 8.3 and
postgis 1.4.1</font>
<br><font size=2 face="sans-serif">I copied the dll in this folder</font>
<br><font size=2 face="sans-serif">C:\Program Files\PostgreSQL\8.3\lib</font>
<br>
<br><font size=2 face="sans-serif">In pgAdminIII I ran rtpostgis.sql and
I get this error</font>
<br><font size=2 face="sans-serif">NOTICE: argument type raster is
only a shell</font>
<br>
<br><font size=2 face="sans-serif">ERROR: function geometry_gist_joinsel(internal,
oid, internal, smallint) does not exist</font>
<br>
<br><font size=2 face="sans-serif">********** Error **********</font>
<br>
<br><font size=2 face="sans-serif">ERROR: function geometry_gist_joinsel(internal,
oid, internal, smallint) does not exist</font>
<br><font size=2 face="sans-serif">SQL state: 42883</font>
<br><font size=2 face="sans-serif"><br>
Please Tell me if there is something I can do</font>
<br><font size=2 face="sans-serif">thanks</font>
<br><font size=2 face="sans-serif">Steve</font>
<p>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Paragon Corporation"
<lr@pcorp.us>@postgis.refractions.net</b> </font>
<br><font size=1 face="sans-serif">Envoyé par : postgis-users-bounces@postgis.refractions.net</font>
<p><font size=1 face="sans-serif">15/01/2010 03:32 PM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Veuillez répondre à<br>
PostGIS Users Discussion <postgis-users@postgis.refractions.net></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">A</font></div>
<td><font size=1 face="sans-serif">"'PostGIS Users Discussion'"
<postgis-users@postgis.refractions.net></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<td><font size=1 face="sans-serif">Re: [postgis-users] RE RE : RE
RE : using WKT Raster</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br>
<br>
<br><font size=2 color=blue face="Arial">Steve,</font>
<br><font size=3> </font>
<br><font size=2 color=blue face="Arial">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.</font>
<br><font size=3> </font>
<br><a href=http://www.postgis.org/download/windows/experimental.php><font size=2 color=blue face="Arial"><u>http://www.postgis.org/download/windows/experimental.php</u></font></a>
<br><font size=3> </font>
<br><font size=2 color=blue face="Arial">Thanks,</font>
<br><font size=2 color=blue face="Arial">Regina</font>
<br>
<br>
<hr><font size=2 face="Tahoma"><b>From:</b> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of
</b>Steve.Toutant@inspq.qc.ca<b><br>
Sent:</b> Friday, January 15, 2010 1:36 PM<b><br>
To:</b> PostGIS Users Discussion<b><br>
Cc:</b> PostGIS Users Discussion; postgis-users-bounces@postgis.refractions.net<b><br>
Subject:</b> [postgis-users] RE RE : RE RE : using WKT Raster</font><font size=3><br>
</font>
<br><font size=2 face="sans-serif"><br>
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.</font><font size=3> </font><font size=2 face="sans-serif"><br>
Running rtpostgis.sql and moving a dll , is that documented somewhere,
maybe I missed it.</font><font size=3> </font><font size=2 face="sans-serif"><br>
Please provide a url if the doc to properly install WKT raster exist.</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
I tried copying rtpostgis.dll into C:\Program Files\PostgreSQL\8.3\lib</font><font size=3>
</font><font size=2 face="sans-serif"><br>
I don't even know if it is the right place.</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
I ran the sql, I got this know</font><font size=3> </font><font size=2 face="sans-serif"><br>
NOTICE: type "raster" is not yet defined</font><font size=3>
</font><font size=2 face="sans-serif"><br>
DETAIL: Creating a shell type definition.</font><font size=3> </font><font size=2 face="sans-serif"><br>
NOTICE: argument type raster is only a shell</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
ERROR: function geometry_samebox(geometry, geometry) does not exist</font><font size=3>
</font><font size=2 face="sans-serif"><br>
LINE 263: AS 'select geometry_samebox($1::geometry, $2::geometry)'</font><font size=3>
</font><font size=2 face="sans-serif"><br>
^</font><font size=3> </font><font size=2 face="sans-serif"><br>
HINT: No function matches the given name and argument types. You
might need to add explicit type casts.</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
********** Error **********</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
ERROR: function geometry_samebox(geometry, geometry) does not exist</font><font size=3>
</font><font size=2 face="sans-serif"><br>
SQL state: 42883</font><font size=3> </font><font size=2 face="sans-serif"><br>
Hint: No function matches the given name and argument types. You might
need to add explicit type casts.</font><font size=3> </font><font size=2 face="sans-serif"><br>
Character: 8525</font><font size=3> </font>
<p><font size=3>thanks </font>
<p><font size=3>Steve </font>
<p><font size=3><br>
<br>
</font>
<table width=100%>
<tr valign=top>
<td width=44%><font size=1 face="sans-serif"><b>Pierre Racine <Pierre.Racine@sbf.ulaval.ca>@postgis.refractions.net</b>
<br>
Envoyé par : postgis-users-bounces@postgis.refractions.net</font><font size=3>
</font>
<p><font size=1 face="sans-serif">15/01/2010 01:15 PM</font><font size=3>
</font>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="sans-serif">Veuillez répondre à<br>
PostGIS Users Discussion <postgis-users@postgis.refractions.net></font></div></table>
<p>
<td width=55%>
<br>
<table width=100%>
<tr valign=top>
<td width=5%>
<div align=right><font size=1 face="sans-serif">A</font></div>
<td width=94%><font size=1 face="sans-serif">PostGIS Users Discussion <postgis-users@postgis.refractions.net></font><font size=3>
</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td><font size=1 face="sans-serif">"postgis-users-bounces@postgis.refractions.net"
<postgis-users-bounces@postgis.refractions.net></font><font size=3>
</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<td><font size=1 face="sans-serif">[postgis-users] RE : RE RE
: using WKT Raster</font></table>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=50%></table>
<br></table>
<br><font size=3><br>
<br>
<br>
<br>
</font><tt><font size=2><br>
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.<br>
<br>
Pierre<br>
________________________________________<br>
De : postgis-users-bounces@postgis.refractions.net [postgis-users-bounces@postgis.refractions.net]
de la part de Steve.Toutant@inspq.qc.ca [Steve.Toutant@inspq.qc.ca]<br>
Date d'envoi : 15 janvier 2010 12:58<br>
À : PostGIS Users Discussion<br>
Cc : postgis-users-bounces@postgis.refractions.net<br>
Objet : [postgis-users] RE RE : using WKT Raster<br>
<br>
I got this error when running the script<br>
NOTICE: type "raster" is not yet defined<br>
DETAIL: Creating a shell type definition.<br>
<br>
ERROR: could not access file "$libdir/rtpostgis": No such
file or directory<br>
<br>
********** Error **********<br>
<br>
ERROR: could not access file "$libdir/rtpostgis": No such file
or directory<br>
SQL state: 58P01<br>
<br>
<br>
<br>
<br>
<br>
Pierre Racine <Pierre.Racine@sbf.ulaval.ca>@postgis.refractions.net<br>
Envoyé par : postgis-users-bounces@postgis.refractions.net<br>
<br>
15/01/2010 04:14 AM<br>
Veuillez répondre à<br>
PostGIS Users Discussion <postgis-users@postgis.refractions.net><br>
<br>
<br>
<br>
<br>
A<br>
PostGIS Users Discussion <postgis-users@postgis.refractions.net><br>
cc<br>
<br>
Objet<br>
[postgis-users] RE : using WKT Raster<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
>How do I get the functions for postgis and how do I enable WKT Raster
extension?<br>
<br>
Steve,<br>
<br>
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.<br>
<br>
This is why it could not find the addrastercolumn function...<br>
<br>
Hope this help,<br>
<br>
Pierre<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@postgis.refractions.net<br>
http://postgis.refractions.net/mailman/listinfo/postgis-users<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@postgis.refractions.net<br>
http://postgis.refractions.net/mailman/listinfo/postgis-users</font></tt><font size=3><br>
<br>
<br>
</font><tt><font size=2>_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@postgis.refractions.net<br>
http://postgis.refractions.net/mailman/listinfo/postgis-users<br>
</font></tt>
<br>
<br>
<br>