<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Buonasera,</p>
<p>mi ritrovo di fronte un problema con la lettura del db postgresql, aggiornato alla versione 12 con il passaggio di versione (da ubuntu 18 a 20)... da qgis non riesco ad accedere ai layer presnti nel db.</p>
<p>questo l'errore nel pannello PostGIS :</p>
<p>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">NOTA: ATTENZIONE: non c'è alcuna transazione in corso</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" color:#dc7d00;">2020-11-16T16:10:52 WARNING </span>Impossibile ottenere dal database l'elenco delle tabelle con dati spaziali</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" color:#dc7d00;">2020-11-16T16:10:59 WARNING </span>Nessun supporto PostGIS nel database.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" color:#dc7d00;">2020-11-16T16:11:03 WARNING </span>Interrogazione errata: SELECT l.f_table_name,l.f_table_schema,l.f_geometry_column,upper(l.type),l.srid,l.coord_dimension,c.relkind,obj_description(c.oid),array_agg(a.attname ORDER BY a.attnum), count(CASE WHEN t.typname IN ('geometry','geography') THEN 1 ELSE NULL END) , 1 FROM geometry_columns l,pg_class c,pg_namespace n,pg_attribute a,pg_type t WHERE c.relname=l.f_table_name AND l.f_table_schema=n.nspname AND NOT a.attisdropped AND a.attrelid=c.oid AND a.atttypid=t.oid AND a.attnum>0 AND n.oid=c.relnamespace AND has_schema_privilege(n.nspname,'usage') AND has_table_privilege(c.oid,'select') AND l.f_table_schema='comune' GROUP BY 1,2,3,4,5,6,7,c.oid,11 UNION SELECT l.f_table_name,l.f_table_schema,l.f_geography_column,upper(l.type),l.srid,2,c.relkind,obj_description(c.oid),array_agg(a.attname ORDER BY a.attnum), count(CASE WHEN t.typname IN ('geometry','geography') THEN 1 ELSE NULL END) , 1 FROM geography_columns l,pg_class c,pg_namespace n,pg_attribute a,pg_type t WHERE c.relname=l.f_table_name AND l.f_table_schema=n.nspname AND NOT a.attisdropped AND a.attrelid=c.oid AND a.atttypid=t.oid AND a.attnum>0 AND n.oid=c.relnamespace AND has_schema_privilege(n.nspname,'usage') AND has_table_privilege(c.oid,'select') AND l.f_table_schema='comune' GROUP BY 1,2,3,4,5,6,7,c.oid,11 ORDER BY 2,1,3 ha restituito 7 [ERRORE: accesso al file "$libdir/postgis-2.4" fallito: File o directory non esistente</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">queste le specifiche :</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<table style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px;" width="100%" cellspacing="2" cellpadding="0"
border="0" align="center">
<tbody>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Versione di QGIS</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">3.10.11-A Coruña</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Revisione codice QGIS</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a href="https://github.com/qgis/QGIS/commit/d2171173e4"><span style=" text-decoration: underline; color:#0000ff;">d2171173e4</span></a></p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Compilato con Qt</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">5.12.8</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Esecuzione con Qt</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">5.12.8</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Compilato con GDAL/OGR</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">3.0.4</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Esecuzione con GDAL/OGR</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">3.0.4</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Compilato con GEOS</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">3.8.0-CAPI-1.13.1</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Esecuzione con GEOS</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">3.8.0-CAPI-1.13.1 </p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Compilato su SQLite</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">3.31.1</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">In esecuzione su SQLite</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">3.31.1</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Versione client PostgreSQL</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">12.4 (Ubuntu 12.4-0ubuntu0.20.04.1)</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Versione SpatiaLite</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">4.3.0a</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Versione QWT</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">6.1.4</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Versione QScintilla2</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">2.11.2</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Compilato con PROJ</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">6.3.1</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Esecuzione con PROJ</p>
</td>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Rel. 6.3.1, February 10th, 2020</p>
</td>
</tr>
<tr>
<td>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Versione SO</p>
</td>
<td colspan="3">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Ubuntu 20.04.1 LTS</p>
</td>
</tr>
</tbody>
</table>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><style type="text/css">
p, li { white-space: pre-wrap; }</style></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Ho cercato in ogni dove qualcosa su questo "$libdir/postgis-2.4" ma non sono riuscito a trovare nulla.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Grazie per ogni indicazione</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">saluti</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Carlo A. Nicolini
</p>
<p><style type="text/css">
p, li { white-space: pre-wrap; }</style></p>
<div class="moz-cite-prefix">Il 15/11/20 21:00,
<a class="moz-txt-link-abbreviated" href="mailto:qgis-it-user-request@lists.osgeo.org">qgis-it-user-request@lists.osgeo.org</a> ha scritto:<br>
</div>
<blockquote type="cite"
cite="mid:mailman.15.1605470402.25493.qgis-it-user@lists.osgeo.org">
<pre class="moz-quote-pre" wrap="">Invia le richieste di iscrizione alla lista QGIS-it-user all'indirizzo
<a class="moz-txt-link-abbreviated" href="mailto:qgis-it-user@lists.osgeo.org">qgis-it-user@lists.osgeo.org</a>
Per iscriverti o cancellarti attraverso il web, visita
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-it-user">https://lists.osgeo.org/mailman/listinfo/qgis-it-user</a>
oppure, via email, manda un messaggio con oggetto `help' all'indirizzo
<a class="moz-txt-link-abbreviated" href="mailto:qgis-it-user-request@lists.osgeo.org">qgis-it-user-request@lists.osgeo.org</a>
Puoi contattare la persona che gestisce la lista all'indirizzo
<a class="moz-txt-link-abbreviated" href="mailto:qgis-it-user-owner@lists.osgeo.org">qgis-it-user-owner@lists.osgeo.org</a>
Se rispondi a questo messaggio, per favore edita la linea dell'oggetto
in modo che sia più utile di un semplice "Re: Contenuti del digest
della lista QGIS-it-user..."
Argomenti del Giorno:
1. Re: Informazioni mancanti in QGIS per la recente aggiunta
della lingua sarda (Totò)
----------------------------------------------------------------------
Message: 1
Date: Sun, 15 Nov 2020 10:53:48 -0700 (MST)
From: Totò <a class="moz-txt-link-rfc2396E" href="mailto:pigrecoinfinito@gmail.com"><pigrecoinfinito@gmail.com></a>
To: <a class="moz-txt-link-abbreviated" href="mailto:qgis-it-user@lists.osgeo.org">qgis-it-user@lists.osgeo.org</a>
Subject: Re: [QGIS-it-user] Informazioni mancanti in QGIS per la
recente aggiunta della lingua sarda
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:1605462828610-0.post@n6.nabble.com"><1605462828610-0.post@n6.nabble.com></a>
Content-Type: text/plain; charset=us-ascii
Ciao Valerio,
non sono un esperto in questo settore ma non puo' essere un problema legato
al formato e dimensione della immagine della bandiera?? almeno nel caso
della finestra della Traduzione.
<a class="moz-txt-link-rfc2396E" href="http://osgeo-org.1560.x6.nabble.com/file/t378656/sardegna.png"><http://osgeo-org.1560.x6.nabble.com/file/t378656/sardegna.png></a>
saluti
-----
<a class="moz-txt-link-freetext" href="https://pigrecoinfinito.wordpress.com/">https://pigrecoinfinito.wordpress.com/</a>
--
Sent from: <a class="moz-txt-link-freetext" href="http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html">http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html</a>
------------------------------
Subject: Chiusura del digest
_______________________________________________
QGIS-it-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-it-user@lists.osgeo.org">QGIS-it-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-it-user">https://lists.osgeo.org/mailman/listinfo/qgis-it-user</a>
------------------------------
Fine di Digest di QGIS-it-user, Volume 61, Numero 16
****************************************************
</pre>
</blockquote>
</body>
</html>