<!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.7601.17573"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial>Virginia,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial>Leo</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=024204623-03062011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </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>Virginia Maffei<BR><B>Sent:</B> Friday, June 03, 2011 1:49 PM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Gdal translate
Error checking geometry type existence problem<BR></FONT><BR></DIV>
<DIV></DIV>Hi, thanks for the response.
<DIV>In the gdal directory y executed this line:</DIV>
<DIV><BR></DIV>
<DIV><SPAN
style="BORDER-COLLAPSE: collapse; FONT-FAMILY: arial, sans-serif; FONT-SIZE: 13px"
class=Apple-style-span>C:\Archivos de programa\GDAL>gdal_translate
PG:"dbname=template_postgis20 user=postgres table=HumedadDeExtincion mode=2"
your_file.tif</SPAN></DIV>
<DIV><FONT class=Apple-style-span face="arial, sans-serif"><SPAN
style="BORDER-COLLAPSE: collapse"
class=Apple-style-span><BR></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, sans-serif"><SPAN
style="BORDER-COLLAPSE: collapse"
class=Apple-style-span><BR></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, sans-serif"><SPAN
style="BORDER-COLLAPSE: collapse" class=Apple-style-span>Does it have something
wrong?</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, sans-serif"><SPAN
style="BORDER-COLLAPSE: collapse"
class=Apple-style-span>thanks!</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, sans-serif"><SPAN
style="BORDER-COLLAPSE: collapse"
class=Apple-style-span>Virginia</SPAN></FONT><BR><BR>
<DIV class=gmail_quote>2011/6/3 Jorge Arévalo <SPAN dir=ltr><<A
href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</A>></SPAN><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Hi Virginia,<BR><BR>This is a GDAL driver's issue, not
PostGIS Raster one. Did you use a<BR>where clause with unescaped single quotes
in your connection string?<BR>This is a common error. Anyway, could you send
me the gdal_translate<BR>line that caused the error?<BR><BR>As Pierre said, it
isn't a good idea to use template_postgis20 to<BR>store data. Create a new
database using the templated instead:<BR><BR>createdb -T template_postgis20 -U
<your_user> -W testing_db<BR><BR>Best regards,<BR>Jorge<BR>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>On Fri, Jun 3, 2011 at 1:24 PM, Pierre Racine<BR><<A
href="mailto:Pierre.Racine@sbf.ulaval.ca">Pierre.Racine@sbf.ulaval.ca</A>>
wrote:<BR>> Did you load/execute rtpostgis.sql in the
database?<BR>><BR>><BR>><BR>> Also, I think this is not good
practice to use your template database<BR>> (template_postgis20) to store
data.<BR>><BR>><BR>><BR>> Pierre<BR>><BR>><BR>><BR>>
From: <A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A><BR>>
[mailto:<A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>]
On Behalf Of Virginia<BR>> Maffei<BR>> Sent: Thursday, June 02, 2011
8:22 PM<BR>> To: PostGIS Users Discussion<BR>> Subject: [postgis-users]
Gdal translate Error checking geometry type<BR>> existence
problem<BR>><BR>><BR>><BR>> Hi, i loaded a tif with
raster2pgsql into the database and now i'm trying to<BR>> get from
that table a tif with gdal_translate.<BR>><BR>> But this error
appears:<BR>><BR>><BR>><BR>> C:\Archivos de
programa\GDAL>gdal_translate PG:"dbname=template_postgis20<BR>>
user=postgres table=HumedadDeExtincion mode=2" your_file.tif<BR>><BR>>
ERROR 1: Error checking geometry type existence. Is PostGIS
correctly<BR>><BR>> installed?: no connection to
the server<BR>><BR>><BR>><BR>> GDALOpen failed - 1<BR>><BR>>
Error checking geometry type existence. Is PostGIS correctly installed?:
no<BR>> connection to the server<BR>><BR>><BR>><BR>> I
installed in windows the postgis raster with gdal, python,
etc.<BR>><BR>><BR>><BR>> Could you please help me with this
problem?<BR>><BR>><BR>><BR>>
Thanks!<BR>><BR>><BR>><BR>>
Virginia<BR>><BR>><BR>><BR>><BR>><BR></DIV></DIV>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>><BR>><BR><BR><BR><BR>--<BR>Jorge
Arévalo<BR>Internet & Mobilty Division, DEIMOS<BR><A
href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</A><BR><A
href="http://es.linkedin.com/in/jorgearevalo80"
target=_blank>http://es.linkedin.com/in/jorgearevalo80</A><BR><A
href="http://mobility.grupodeimos.com/"
target=_blank>http://mobility.grupodeimos.com/</A><BR><A
href="http://gis4free.wordpress.com"
target=_blank>http://gis4free.wordpress.com</A><BR><A
href="http://geohash.org/ezjqgrgzz0g"
target=_blank>http://geohash.org/ezjqgrgzz0g</A><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>