<br><font size=2 face="sans-serif">ok, installation successfull using the
readme.txt and Pierre'note below</font>
<br><font size=2 face="sans-serif">thanks</font>
<br><font size=2 face="sans-serif">Steve</font>
<br><font size=2 face="sans-serif"><br>
</font><font size=3 color=#0066ff><i>Steve Toutant, M. Sc.</i></font><font size=3><br>
Analyste en géomatique<br>
Secteur environnement<br>
Direction de la santé environnementale et de la toxicologie<br>
Institut national de santé publique du Québec<br>
945, avenue Wolfe<br>
Québec, Qc G1V 5B3 </font>
<p><font size=3>Tél.: (418) 650-5115 #5281<br>
Fax.: (418) 654-3144</font><font size=3 color=blue><u><br>
</u></font><a href=mailto:steve.toutant@inspq.qc.ca><font size=3 color=blue><u>steve.toutant@inspq.qc.ca</u></font></a><font size=3 color=blue><u><br>
</u></font><a href=http://www.inspq.qc.ca/><font size=3 color=blue><u>http://www.inspq.qc.ca</u></font></a>
<p><font size=3> </font>
<p>
<br>
<br>
<br>
<table width=100%>
<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 05:03 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><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
: RE RE : using WKT Raster</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br>
<br>
<br><tt><font size=2>Search for geometry_gist_joinsel in rtpostgis.sql,
replace it with postgis_gist_joinsel and rexecute the file.<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 16:00<br>
À : PostGIS Users Discussion<br>
Cc : postgis-users-bounces@postgis.refractions.net<br>
Objet : Re: [postgis-users] RE RE : RE RE : using
WKT Raster<br>
<br>
Hi Regina,<br>
I'm on winXP. I use postgres 8.3 and postgis 1.4.1<br>
I copied the dll in this folder<br>
C:\Program Files\PostgreSQL\8.3\lib<br>
<br>
In pgAdminIII I ran rtpostgis.sql and I get this error<br>
NOTICE: argument type raster is only a shell<br>
<br>
ERROR: function geometry_gist_joinsel(internal, oid, internal, smallint)
does not exist<br>
<br>
********** Error **********<br>
<br>
ERROR: function geometry_gist_joinsel(internal, oid, internal, smallint)
does not exist<br>
SQL state: 42883<br>
<br>
Please Tell me if there is something I can do<br>
thanks<br>
Steve<br>
<br>
<br>
<br>
"Paragon Corporation" <lr@pcorp.us>@postgis.refractions.net<br>
Envoyé par : postgis-users-bounces@postgis.refractions.net<br>
<br>
15/01/2010 03:32 PM<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>
Re: [postgis-users] RE RE : RE
RE : using WKT Raster<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Steve,<br>
<br>
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.<br>
<br>
http://www.postgis.org/download/windows/experimental.php<br>
<br>
Thanks,<br>
Regina<br>
<br>
<br>
________________________________<br>
From: postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net]
On Behalf Of Steve.Toutant@inspq.qc.ca<br>
Sent: Friday, January 15, 2010 1:36 PM<br>
To: PostGIS Users Discussion<br>
Cc: PostGIS Users Discussion; postgis-users-bounces@postgis.refractions.net<br>
Subject: [postgis-users] RE RE : RE RE : using WKT Raster<br>
<br>
<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.<br>
Running rtpostgis.sql and moving a dll , is that documented somewhere,
maybe I missed it.<br>
Please provide a url if the doc to properly install WKT raster exist.<br>
<br>
I tried copying rtpostgis.dll into C:\Program Files\PostgreSQL\8.3\lib<br>
I don't even know if it is the right place.<br>
<br>
I ran the sql, I got this know<br>
NOTICE: type "raster" is not yet defined<br>
DETAIL: Creating a shell type definition.<br>
NOTICE: argument type raster is only a shell<br>
<br>
ERROR: function geometry_samebox(geometry, geometry) does not exist<br>
LINE 263: AS 'select geometry_samebox($1::geometry, $2::geometry)'<br>
^<br>
HINT: No function matches the given name and argument types. You
might need to add explicit type casts.<br>
<br>
********** Error **********<br>
<br>
ERROR: function geometry_samebox(geometry, geometry) does not exist<br>
SQL state: 42883<br>
Hint: No function matches the given name and argument types. You might
need to add explicit type casts.<br>
Character: 8525<br>
<br>
thanks<br>
<br>
Steve<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 01:15 PM<br>
Veuillez répondre à<br>
PostGIS Users Discussion <postgis-users@postgis.refractions.net><br>
<br>
<br>
A<br>
PostGIS Users Discussion <postgis-users@postgis.refractions.net><br>
cc<br>
"postgis-users-bounces@postgis.refractions.net"
<postgis-users-bounces@postgis.refractions.net><br>
Objet<br>
[postgis-users] RE : RE RE : using
WKT Raster<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<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<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>