[postgis-users] problem installing WKTRaster

Mon Jul 19 09:50:56 PDT 2010

Yeap Pierre, this is 8.3.

I'll do that and i'll get back to you. Thanks for the quick answer.

George

On Mon, Jul 19, 2010 at 1:27 PM, Pierre Racine
<Pierre.Racine at sbf.ulaval.ca>wrote:

>  You’re using PostgreSQL 8.3 right?
>
>
>
> Replace
>
>
>
> “SELECT ST_Intersection((gv).geom, $1) intgeom”
>
>
>
> with
>
>
>
> “SELECT ST_Intersection((gv).geom, $1) AS intgeom”…
>
>
>
> I’ll fix the source.
>
>
>
> Pierre
>
>
>
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *George Silva
> *Sent:* 19 juillet 2010 12:11
>
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] problem installing WKTRaster
>
>
>
> While we are at it, I've tried installing and there it complains about an
> error here:
>
> My download link was:
> http://www.postgis.org/download/windows/pg83/experimental/wktraster/wktraster_pg83.zip
>
> I've already placed all my files at the correct place. What is the name of
> the environment variable for postgresql? Just "PATH"? I already have two or
> three variables with that name...
>
> Any ideas? Thanks guys.
>
>
> CREATE OR REPLACE FUNCTION st_intersection(geom geometry, rast raster, band
> integer)
>     RETURNS SETOF geomval AS
>     $$
>         -- Return the intersections of the geometry with the vectorized
> parts of
>         -- the raster and the values associated with those parts, if really
> their
>         -- intersection is not empty.
>         SELECT intgeom, val
>         FROM (
>             SELECT ST_Intersection((gv).geom, $1) intgeom, (gv).val
>             FROM ST_DumpAsPolygons($2, $3) gv
>             WHERE ST_Intersects((gv).geom, $1) AND ST_Intersects($1, $2,
> $3)) foo
>         WHERE NOT st_isempty(intgeom)  -- eliminate empty intersections
>         UNION ALL
>         -- If the geometry does not intersect with the raster, return an
> empty
>         -- geometry and a null value
>         SELECT emptygeom, NULL FROM
>         ST_GeomCollFromText('GEOMETRYCOLLECTION EMPTY', st_srid($1))
> emptygeom
>         WHERE NOT ST_Intersects($1, $2, $3);
>     $$
>     LANGUAGE SQL IMMUTABLE;
>
> NOTICE:  type "raster" is not yet defined
> DETAIL:  Creating a shell type definition.NOTICE:  argument type raster is
> only a shell
>
> ERROR:  syntax error at or near "intgeom"
> LINE 1219:             SELECT ST_Intersection((gv).geom, $1) intgeom, (...
>                                                              ^
>
> ********** Error **********
>
> ERROR: syntax error at or near "intgeom"
> SQL state: 42601
> Character: 44614
>
>  On Mon, Jul 19, 2010 at 12:37 PM, Paragon Corporation <lr at pcorp.us>
> wrote:
>
> Sebastian,
>
>
>
> Oops sorry about that.  Will correct the readme.txt.
>
>
>
> Leo
>
> http://www.postgis.us
>
>
>  ------------------------------
>
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Sebastian E.
> Ovide
> *Sent:* Monday, July 19, 2010 9:08 AM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] problem installing WKTRaster
>
> Re reading the readme.txt
>
> 1) Install PostGIS into your database if you haven't already
> 2) Copy the rtpostgis.dll to the lib folder of your PostgreSQL install
> 3)
> a) then Run the share\contrib\postgis\rtpostgis.sql in your postgis enabled
> db
> b) You can install help now too by running
> share\contrib\postgis\wktraster_comments.sql
> 4) Copy the contents of bin to your PostgreSQL bin folder
> (gdal2wktraster.py, libgdal.dll) to bin folder of your PostgreSQL install.
>
> the point 4 should come before the point 3....
>
> On Mon, Jul 19, 2010 at 12:13 PM, Sebastian E. Ovide <
> sebastian.ovide at gmail.com> wrote:
>
> Hi Fred,
>
> Thanks to that Tool I've discovered that the dll could not find
> libgdal.dll... so I've copied it into the bin dir and now it works !
>
> thanks !
>
>
>
> On Mon, Jul 19, 2010 at 12:03 PM, Fred Lehodey <lehodey at gmail.com> wrote:
>
> Hi Sebastian,
> you can try that free utility : http://www.dependencywalker.com/
>
> Sometimes helpful to discover a missing file.
>
> Fred.
>
>
>
>
>
>  On Mon, Jul 19, 2010 at 11:56 AM, Sebastian E. Ovide <
> sebastian.ovide at gmail.com> wrote:
>
> same:
>
>
> ERROR:  could not load library "C:/Program
> Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not be
> found.
>
> 2010/7/19 Jorge Arévalo <jorge.arevalo at deimos-space.com>
>
> On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E. Ovide
>
> <sebastian.ovide at gmail.com> wrote:
>
> > done, same problem
> >
> > ERROR:  could not load library "C:/Program
> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not
> be
> > found.
> >
>
> Try adding C:/Program Files/PostgreSQL/8.4/lib/ to the PATH enviroment
> variable.
>
>
>
> > 2010/7/19 Jorge Arévalo <jorge.arevalo at deimos-space.com>
> >>
> >> On Mon, Jul 19, 2010 at 11:01 AM, Sebastian E. Ovide
> >> <sebastian.ovide at gmail.com> wrote:
> >> > Hi All,
> >> >
> >> > on WinXP, with PostgreSLQ 8.4, PostGis 1.5 and WKTRaster 0.1.6d.
> >> >
> >> > Just followed the instructions from WKTRaster 0.1.6d readme.txt and
> when
> >> > I'm
> >> > running the rtpostgis.sql I'm getting this error:
> >> >
> >> > NOTICE:  type "raster" is not yet defined
> >> > DETAIL:  Creating a shell type definition.
> >> > ERROR:  could not load library "C:/Program
> >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could
> not
> >> > be
> >> > found.
> >> >
> >> >
> >> > ********** Error **********
> >> >
> >> > ERROR: could not load library "C:/Program
> >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could
> not
> >> > be
> >> > found.
> >> > SQL state: 58P01
> >> >
> >> >
> >> > But I do have that file !!!!
> >> >
> >> > C:\Documents and Settings\sebastian ovide>dir "C:\Program
> >> > Files\PostgreSQL\8.4\lib\rtpostgis.dll"
> >> >  Volume in drive C has no label.
> >> >  Volume Serial Number is 2079-A57D
> >> >
> >> >  Directory of C:\Program Files\PostgreSQL\8.4\lib
> >> >
> >> > 21/06/2010  13:52           210,432 rtpostgis.dll
> >> >                1 File(s)        210,432 bytes
> >> >                0 Dir(s)  450,924,576,768 bytes free
> >> >
> >> >
> >> > now, If I use the backslash... ( as for the error)
> >> >
> >> >
> >> > C:\Documents and Settings\sebastian ovide>dir "C:/Program
> >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll"
> >> >  Volume in drive C has no label.
> >> >  Volume Serial Number is 2079-A57D
> >> >
> >> >  Directory of C:\Program Files\PostgreSQL\8.4\lib
> >> >
> >> > File Not Found
> >> >
> >> >
> >> >
> >> > ideas ?
> >> >
> >> > thanks
> >> >
> >> > --
> >> > Sebastian E. Ovide
> >> >
> >>
> >> Hi,
> >>
> >> Try copying rtpostgis.dll in C:\Program Files\PostgreSQL\8.4\bin
> directory
> >>
> >> Best regards,
> >>
> >> --
> >> Jorge Arévalo
> >> DEIMOS Space
> >> Internet & Mobilty Division
> >> Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º
> >> 28760 Tres Cantos (Madrid)
> >> Tel: +34 91 806 34 50 - ext: 155
> >> jorge.arevalo at deimos-space.com
> >> http://gis4free.wordpress.com
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> > --
> > Sebastian E. Ovide
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
>
>
> --
> Jorge Arévalo
> DEIMOS Space
> Internet & Mobilty Division
> Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º
> 28760 Tres Cantos (Madrid)
> Tel: +34 91 806 34 50 - ext: 155
> jorge.arevalo at deimos-space.com
> http://gis4free.wordpress.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>   --
> Sebastian E. Ovide
>
> skype: sebastian.ovide
>
> +353 (0) 87 6340149
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
>
>   --
> Sebastian E. Ovide
>
>
>
>
>
>
> --
> Sebastian E. Ovide
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> --
> George R. C. Silva
>
> Desenvolvimento em GIS
> http://blog.geoprocessamento.net
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>

-- 
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100719/97505e84/attachment.html>