<!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 9.00.8112.16448">
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=2 face=Arial>Antonio,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>The problem is solved. I followed up with
postgis via the ticket you mentioned in your message. Their advise, to
install legacy.sql, fixed the problem. This is what posgis
said:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px" dir=ltr>
<DIV><FONT size=2 face=Arial><EM>Comment(by robe):</EM></FONT></DIV>
<DIV><FONT size=2 face=Arial><EM></EM></FONT> </DIV>
<DIV><FONT size=2 face=Arial><EM> Al,</EM></FONT></DIV>
<DIV><FONT size=2 face=Arial><EM></EM></FONT> </DIV>
<DIV><FONT size=2 face=Arial><EM> You can try installing the legacy.sql
file packaged with PostGIS 2.0 that<BR> is in share/contrib/postgis-2.0
folder (where the other PostGIS scripts<BR> are). That reinstalls
all the legacy functions we took out and resolves<BR> many of these kinds
of issues.</EM></FONT></DIV>
<DIV><FONT size=2 face=Arial><EM></EM></FONT> </DIV>
<DIV><FONT size=2 face=Arial><EM> If that still doesn't work, can you
turn on logging on your database and<BR> let us know what errors you are
seeing in the logs.</EM></FONT></DIV>
<DIV><FONT size=2 face=Arial><EM></EM></FONT> </DIV>
<DIV><FONT size=2 face=Arial><EM> to turn on logging do the following -
replace mygisdb with the name of the<BR> database you are connecting
to.</EM></FONT></DIV>
<DIV><FONT size=2 face=Arial><EM></EM></FONT> </DIV>
<DIV><FONT size=2 face=Arial><EM> {{{<BR> ALTER DATABASE mygisdb SET
log_statement='all';<BR> }}}</EM></FONT></DIV>
<DIV><FONT size=2 face=Arial><EM></EM></FONT> </DIV>
<DIV><FONT size=2 face=Arial><EM> The logs are usually written to the
pg_logs folder of your PostgreSQL data<BR> folder.<BR> Check the
latest one -- usually notes the missing function or issue
with<BR> call.<BR></EM><BR>> Il 17/08/2012 21.12, Al Vigil ha
scritto:<BR>>> I have no trouble displaying shp files, only PostGis
GeoDb tables.<BR>>> Am using the binaries for Postgresql 9.1 and PostGis
2.0.1 running under<BR>>> Windows Vista. The vectors<BR>>>
are stored in a geometry column and am using projection 4326 on
the<BR>>> View, the same projection as the table.<BR>> <BR>> Hi
Al,<BR>> I think that the issue is probably due to your PostGIS version,
because<BR>> gvSIG 1.1x actually supports only PostGIS 1.x and not the
latest 2.0.<BR>> In reference to this there's also a ticket in the PostGIS
bug tracker [1].<BR>> IMHO adding the PostGIS 2.0 support is a useful
feature request, but I<BR>> don't know if developers have enough time and
resources to solve this<BR>> problem right now that gvSIG 1.12 final is
going to be released.<BR>> <BR>> Cheers,<BR>> Antonio<BR>>
<BR>> [1] </FONT><A href="http://trac.osgeo.org/postgis/ticket/833"><FONT
size=2 face=Arial>http://trac.osgeo.org/postgis/ticket/833</FONT></A><BR><FONT
size=2 face=Arial>> <BR>> -- <BR>> Antonio Falciano<BR>> </FONT><A
href="http://www.linkedin.com/in/antoniofalciano"><FONT size=2
face=Arial>http://www.linkedin.com/in/antoniofalciano</FONT></A><BR><FONT
size=2 face=Arial>> <BR>> <BR>>
------------------------------<BR>> <BR>>
_______________________________________________<BR>> Gvsig_internacional
mailing list<BR>> </FONT><A
href="mailto:Gvsig_internacional@listserv.gva.es"><FONT size=2
face=Arial>Gvsig_internacional@listserv.gva.es</FONT></A><BR><FONT size=2
face=Arial>> </FONT><A
href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional"><FONT
size=2
face=Arial>http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</FONT></A><BR><FONT
size=2 face=Arial>> <BR>> <BR>> End of Gvsig_internacional Digest,
Vol 79, Issue 10<BR>>
***************************************************</FONT></DIV></BLOCKQUOTE></BODY></HTML>