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

[Pierre Racine]

Search for geometry_gist_joinsel in rtpostgis.sql, replace it with postgis_gist_joinsel and rexecute the file.

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 16:00
À : PostGIS Users Discussion
Cc : postgis-users-bounces at postgis.refractions.net
Objet : Re: [postgis-users] RE  RE :  RE  RE :  using WKT Raster

Hi Regina,
I'm on winXP. I use postgres 8.3 and postgis 1.4.1
I copied the dll in this folder
C:\Program Files\PostgreSQL\8.3\lib

In pgAdminIII I ran rtpostgis.sql and I get this error
NOTICE:  argument type raster is only a shell

ERROR:  function geometry_gist_joinsel(internal, oid, internal, smallint) does not exist

********** Error **********

ERROR: function geometry_gist_joinsel(internal, oid, internal, smallint) does not exist
SQL state: 42883

Please Tell me if there is something I can do
thanks
Steve



"Paragon Corporation" <lr at pcorp.us>@postgis.refractions.net
Envoyé par : postgis-users-bounces at postgis.refractions.net

15/01/2010 03:32 PM
Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>




A
        "'PostGIS Users Discussion'" <postgis-users at postgis.refractions.net>
cc

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









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


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users