On Tue, Apr 5, 2011 at 13:17, Martin Landa <span dir="ltr"><<a href="mailto:landa.martin@gmail.com">landa.martin@gmail.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi,<br>
<br>
2011/4/5 Eloi Ribeiro <<a href="mailto:eloi.ribeiro@gmail.com">eloi.ribeiro@gmail.com</a>>:<br>
<div class="im">> This is what I'm trying to do:<br>
> v.in.ogr dsn="PG:host=localhost dbname=bd_ceamsig user=postgres"<br>
> layer=sch_ambiente.escv_incendios_todos where="anyo=2009" output=temp<br>
<br>
</div>missing `format=PostgreSQL` ?<br>
<br>
Martin<br>
<font color="#888888"><br>
</font></blockquote></div><div><br></div>Thanks for your quick reply Martin,<div><br><div>Actually it's not a format parameter that I miss but a parameter that would define which <meta http-equiv="content-type" content="text/html; charset=utf-8">geometry I want to use in case there is more than one geometry per layer/postgis table.</div>
<div><br></div><div><meta http-equiv="content-type" content="text/html; charset=utf-8">Example. In my table '<i>escv_incendios_todos'</i> I have tow filds/columns with geometry, one is called geom_23030 (coord. syst. epsg 23030) and the other geom_4258 (coord. syst. epsg 4258) and a trigger maintaining this tow geometry's synchronized. In the geometry_columns table there are tow entry's for the '<i>escv_incendios_todos' </i>table:</div>
<meta http-equiv="content-type" content="text/html; charset=utf-8"><div><br></div><div>3970433;"''";"sch_ambiente";"escv_incendios_todos";"geom_23030";2;23030;"MULTIPOLYGON"</div>
<div>3970434;"''";"sch_ambiente";"escv_incendios_todos";"geom_4258";2;4258;"MULTIPOLYGON"</div><meta http-equiv="content-type" content="text/html; charset=utf-8"><meta http-equiv="content-type" content="text/html; charset=utf-8"><div>
<br></div><div>So when I try to load <meta http-equiv="content-type" content="text/html; charset=utf-8">'<i>escv_incendios_todos'</i> in GRASS there is no way to define which geometry I want to use. And the error <span class="Apple-style-span" style="border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px; "> 'ERROR: Layer <layer_name> not available' jumps out.</span></div>
<div><span class="Apple-style-span" style="border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px; "><br></span></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">By now I worked around by deleting the entry with the geometry I'm not interested on the </span></font>geometry_columns table and then insert it again.</div>
<meta http-equiv="content-type" content="text/html; charset=utf-8"><meta http-equiv="content-type" content="text/html; charset=utf-8"><div><br><meta http-equiv="content-type" content="text/html; charset=utf-8"><span class="Apple-style-span" style="border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px; ">Thanks. Regards,</span></div>
</div>