[postgis-users] Gdal translate Error checking geometry type existence problem

[Virginia Maffei]

Now i'm having another error. I created another post: "Problem with postgis
raster using gdal_translate"

thanks!
Virginia


On Fri, Jun 3, 2011 at 8:49 PM, Paragon Corporation <lr at pcorp.us> wrote:

>  Virginia,
>
> I see your table is mixed casing in you statement.  Is your table mixed
> case  in PostgreSQL.  Not sure if gdal_translate takes your casing literally
> or not.
>
> I would suggest making sure all your tables are lower case in the
> database and lower case in your gdal_translate as well just to make sure.
>
> Leo
> http://www.postgis.us
>
>
>  ------------------------------
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Virginia
> Maffei
> *Sent:* Friday, June 03, 2011 1:49 PM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] Gdal translate Error checking geometry type
> existence problem
>
> Hi, thanks for the response.
> In the gdal directory y executed this line:
>
> C:\Archivos de programa\GDAL>gdal_translate PG:"dbname=template_postgis20
> user=postgres table=HumedadDeExtincion mode=2" your_file.tif
>
>
> Does it have something wrong?
> thanks!
> Virginia
>
> 2011/6/3 Jorge Arévalo <jorge.arevalo at deimos-space.com>
>
>> Hi Virginia,
>>
>> This is a GDAL driver's issue, not PostGIS Raster one. Did you use a
>> where clause with unescaped single quotes in your connection string?
>> This is a common error. Anyway, could you send me the gdal_translate
>> line that caused the error?
>>
>> As Pierre said, it isn't a good idea to use template_postgis20 to
>> store data. Create a new database using the templated instead:
>>
>> createdb -T template_postgis20 -U <your_user> -W testing_db
>>
>> Best regards,
>> Jorge
>>
>> On Fri, Jun 3, 2011 at 1:24 PM, Pierre Racine
>> <Pierre.Racine at sbf.ulaval.ca> wrote:
>> > Did you load/execute rtpostgis.sql in the database?
>> >
>> >
>> >
>> > Also, I think this is not good practice to use your template database
>> > (template_postgis20) to store data.
>> >
>> >
>> >
>> > Pierre
>> >
>> >
>> >
>> > From: postgis-users-bounces at postgis.refractions.net
>> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
>> Virginia
>> > Maffei
>> > Sent: Thursday, June 02, 2011 8:22 PM
>> > To: PostGIS Users Discussion
>> > Subject: [postgis-users] Gdal translate Error checking geometry type
>> > existence problem
>> >
>> >
>> >
>> > Hi, i loaded a tif with raster2pgsql into the database and now i'm
>> trying to
>> > get from that table a tif with gdal_translate.
>> >
>> > But this error appears:
>> >
>> >
>> >
>> > C:\Archivos de programa\GDAL>gdal_translate
>> PG:"dbname=template_postgis20
>> > user=postgres table=HumedadDeExtincion mode=2" your_file.tif
>> >
>> > ERROR 1: Error checking geometry type existence. Is PostGIS correctly
>> >
>> >       installed?: no connection to the server
>> >
>> >
>> >
>> > GDALOpen failed - 1
>> >
>> > Error checking geometry type existence. Is PostGIS correctly installed?:
>> no
>> > connection to the server
>> >
>> >
>> >
>> > I installed in windows the postgis raster with gdal, python, etc.
>> >
>> >
>> >
>> > Could you please help me with this problem?
>> >
>> >
>> >
>> > Thanks!
>> >
>> >
>> >
>> > Virginia
>> >
>> >
>> >
>> >
>> >
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users at postgis.refractions.net
>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >
>> >
>>
>>
>>
>> --
>> Jorge Arévalo
>> Internet & Mobilty Division, DEIMOS
>> jorge.arevalo at deimos-space.com
>> http://es.linkedin.com/in/jorgearevalo80
>> http://mobility.grupodeimos.com/
>> http://gis4free.wordpress.com
>> http://geohash.org/ezjqgrgzz0g
>> _______________________________________________
>> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110605/d415dbcc/attachment.html>