<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18854"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=375493020-15012010>Steve,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=375493020-15012010></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=375493020-15012010>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=375493020-15012010></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=375493020-15012010><A
href="http://www.postgis.org/download/windows/experimental.php">http://www.postgis.org/download/windows/experimental.php</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=375493020-15012010></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=375493020-15012010>Thanks,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=375493020-15012010>Regina</SPAN></FONT></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<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<BR><B>Sent:</B> Friday, January 15, 2010 1:36
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Cc:</B> PostGIS Users
Discussion; postgis-users-bounces@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] RE RE : RE RE : using WKT Raster<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT size=2 face=sans-serif>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> <BR><FONT size=2
face=sans-serif>Running rtpostgis.sql and moving a dll , is that documented
somewhere, maybe I missed it.</FONT> <BR><FONT size=2 face=sans-serif>Please
provide a url if the doc to properly install WKT raster exist.</FONT>
<BR><BR><FONT size=2 face=sans-serif>I tried copying rtpostgis.dll into
C:\Program Files\PostgreSQL\8.3\lib</FONT> <BR><FONT size=2 face=sans-serif>I
don't even know if it is the right place.</FONT> <BR><BR><FONT size=2
face=sans-serif>I ran the sql, I got this know</FONT> <BR><FONT size=2
face=sans-serif>NOTICE: type "raster" is not yet defined</FONT> <BR><FONT
size=2 face=sans-serif>DETAIL: Creating a shell type definition.</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_samebox(geometry, geometry) does not exist</FONT> <BR><FONT size=2
face=sans-serif>LINE 263: AS 'select
geometry_samebox($1::geometry, $2::geometry)'</FONT> <BR><FONT size=2
face=sans-serif>
^</FONT> <BR><FONT size=2 face=sans-serif>HINT:
No function matches the given name and argument types. You might need to
add explicit type casts.</FONT> <BR><BR><FONT size=2 face=sans-serif>**********
Error **********</FONT> <BR><BR><FONT size=2 face=sans-serif>ERROR: function
geometry_samebox(geometry, geometry) does not exist</FONT> <BR><FONT size=2
face=sans-serif>SQL state: 42883</FONT> <BR><FONT size=2 face=sans-serif>Hint:
No function matches the given name and argument types. You might need to add
explicit type casts.</FONT> <BR><FONT size=2 face=sans-serif>Character:
8525</FONT>
<P><FONT size=3>thanks</FONT>
<P><FONT size=3>Steve</FONT>
<P><BR><BR><BR>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD width="40%"><FONT size=1 face=sans-serif><B>Pierre Racine
<Pierre.Racine@sbf.ulaval.ca>@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 01:15 PM</FONT>
<TABLE border=1>
<TBODY>
<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></TR></TBODY></TABLE><BR></P>
<TD width="59%">
<TABLE width="100%">
<TBODY>
<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><FONT size=1
face=sans-serif>"postgis-users-bounces@postgis.refractions.net"
<postgis-users-bounces@postgis.refractions.net></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></TR></TBODY></TABLE><BR>
<TABLE>
<TBODY>
<TR vAlign=top>
<TD>
<TD></TR></TBODY></TABLE><BR></TR></TBODY></TABLE><BR><BR><BR><BR><BR><TT><FONT
size=2>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<BR></FONT></TT><BR><BR><BR></P></BODY></HTML>