<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Ciao Ragà.<br>
      La tabella "LEFT" ha un campo id numerico di tipo bigint ed ha una
      constraint di PRIMARY KEY.<br>
      Per quanto riguarda le varie LEFT JOIN, non fanno altro che
      collegare chiavi primarie delle tabelle "RIGHT" con le chiavi
      esterne nella tabella "LEFT".<br>
      Ho fatto eseguire sulla vista la seguente query e non ha dato
      conteggi maggiori di 1.<br>
      <small><small><font color="#cc0000">SELECT id, COUNT(id)<br>
              FROM v_poi_airport<br>
             GROUP BY id<br>
            ORDER BY COUNT(id) DESC;</font></small></small><br>
      <br>
      Il 02/02/2014 23:14, Luca Mandolesi ha scritto:<br>
    </div>
    <blockquote
cite="mid:CAHmdnV6-+0ns-=CfOOAO3+BKYMCkDNm3wgaC_dvArVs8vTLD3g@mail.gmail.com"
      type="cite">
      <div dir="ltr">Mi ha battuto sul tempo Andrea... io nelle mie view
        setto sempre la query con Join per evitare tale problema. Se ad
        un punto corrispondo più record della tabella alfanumerica, puoi
        provare a dare dentro al provider di postgis come id singolo la
        chiave primaria e quindi unica della tabella 2.</div>
      <div class="gmail_extra"><br>
        <br>
        <div class="gmail_quote">2014-02-02 Andrea Peri <span dir="ltr"><<a
              moz-do-not-send="true" href="mailto:aperi2007@gmail.com"
              target="_blank">aperi2007@gmail.com</a>></span>:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">
              <div>
                <div>ok.<br>
                  <br>
                </div>
                Un altro suggerimento:<br>
                <br>
              </div>
              <div>qgis per il postgres vole disporre di un campo che
                sia di tipo intero e con una primary-key.<br>
                Oppure con un indice di tipo unique.<br>
              </div>
              <div>Verifica che questa condizione sia verificata su uno
                dei campi che definisci nella vista.<br>
                Stai attento che la condizione LEFTJOIN potrebbe falsare
                questa consizione provocando la ripetizione di records.<br>
                <br>
              </div>
              <div><br>
              </div>
            </div>
            <div class="gmail_extra"><br>
              <br>
              <div class="gmail_quote">Il giorno 02 febbraio 2014 22:58,
                Marco Li Volsi <span dir="ltr"><<a
                    moz-do-not-send="true"
                    href="mailto:marco.livolsi@gmail.com"
                    target="_blank">marco.livolsi@gmail.com</a>></span>
                ha scritto:
                <div>
                  <div class="h5"><br>
                    <blockquote class="gmail_quote" style="margin:0 0 0
                      .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div text="#000000" bgcolor="#FFFFFF">
                        <div>Grazie Andrea... ho provato ma non funge
                          :-(<br>
                          <br>
                          Il 02/02/2014 22:43, Andrea Peri ha scritto:<br>
                        </div>
                        <div>
                          <div>
                            <blockquote type="cite">
                              <div dir="ltr">
                                <div>Prova a modificare la view
                                  definendo la geometria in quesot modo:<br>
                                  <br>
                                  ..,
                                  tabella1.campogeometrico::geometry(Geometry,
                                  3003) As geom<br>
                                  <br>
                                </div>
                                Io ho scritto 3003 ipotizzando che il
                                dato sia in GaussBoaga, se è utm usa
                                25832 o altro codice epsg.<br>
                                <br>
                                <div><br>
                                </div>
                              </div>
                              <div class="gmail_extra"><br>
                                <br>
                                <div class="gmail_quote">Il giorno 02
                                  febbraio 2014 21:47, Marco Li Volsi <span
                                    dir="ltr"><<a
                                      moz-do-not-send="true"
                                      href="mailto:marco.livolsi@gmail.com"
                                      target="_blank">marco.livolsi@gmail.com</a>></span>
                                  ha scritto:<br>
                                  <blockquote class="gmail_quote"
                                    style="margin:0 0 0
                                    .8ex;border-left:1px #ccc
                                    solid;padding-left:1ex">
                                    <div text="#000000"
                                      bgcolor="#FFFFFF"> Buona sera a
                                      tutti Voi.<br>
                                      Ho un comportamento molto strano
                                      riguardo al caricamento di una
                                      vista geografica su PostGIS.<br>
                                      Ho creato una vista su PostGIS del
                                      tipo<br>
                                      <font color="#cc0000"><small><small>CREATE
                                            OR REPLACE VIEW vista1<br>
                                                SELECT tabella1.campo1,
                                            tabella2.campo2,<big><big> </big></big></small></small><small><small>tabella1.campo2<big><big>,</big><small>
                                                ...</small>,</big>
                                            tabella1.campogeometrico<br>
                                                FROM tabella1<br>
                                                LEFT JOIN tabella2 ON
                                            ...<br>
                                                WHERE tabella1.campo2 =
                                            valore;</small></small></font><br>
                                      La vista viene correttamente
                                      trovata nella vista
                                      geometry_columns.<br>
                                      Ho provato a caricare questo layer
                                      dal tasto "Aggiungi vettore
                                      PostGIS" e mi viene restituito un
                                      messaggio di alert. Verificando il
                                      registro degli eventi il layer
                                      risulta non valido. Se provo a
                                      caricare il layer dal DB Manager
                                      tutto va come deve andare.<br>
                                      Il sistema in questione è QGIS
                                      2.0.1-Dufour e POSTGIS="2.0.1
                                      r9979" GEOS="3.3.3-CAPI-1.7.4"
                                      PROJ="Rel. 4.8.0, 6 March 2012"
                                      GDAL="GDAL 1.9.2, released
                                      2012/10/08" LIBXML="2.7.8" RASTER.<br>
                                      Qualcuno saprebbe dirmi se sbaglio
                                      qualcosa?<br>
                                    </div>
                                    <br>
_______________________________________________<br>
                                    <a moz-do-not-send="true"
                                      href="mailto:Gfoss@lists.gfoss.it"
                                      target="_blank">Gfoss@lists.gfoss.it</a><br>
                                    <a moz-do-not-send="true"
                                      href="http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss"
                                      target="_blank">http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss</a><br>
                                    Questa e' una lista di discussione
                                    pubblica aperta a tutti.<br>
                                    I messaggi di questa lista non hanno
                                    relazione diretta con le posizioni
                                    dell'Associazione GFOSS.it.<br>
                                    666 iscritti al 22.7.2013<br>
                                  </blockquote>
                                </div>
                                <br>
                                <br clear="all">
                                <br>
                                -- <br>
                                -----------------<br>
                                Andrea Peri<br>
                                . . . . . . . . . <br>
                                qwerty àèìòù<br>
                                -----------------<br>
                              </div>
                            </blockquote>
                            <br>
                          </div>
                        </div>
                      </div>
                      <br>
                      _______________________________________________<br>
                      <a moz-do-not-send="true"
                        href="mailto:Gfoss@lists.gfoss.it"
                        target="_blank">Gfoss@lists.gfoss.it</a><br>
                      <a moz-do-not-send="true"
                        href="http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss"
                        target="_blank">http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss</a><br>
                      Questa e' una lista di discussione pubblica aperta
                      a tutti.<br>
                      I messaggi di questa lista non hanno relazione
                      diretta con le posizioni dell'Associazione
                      GFOSS.it.<br>
                      666 iscritti al 22.7.2013<br>
                    </blockquote>
                  </div>
                </div>
              </div>
              <div>
                <div class="h5"><br>
                  <br clear="all">
                  <br>
                  -- <br>
                  -----------------<br>
                  Andrea Peri<br>
                  . . . . . . . . . <br>
                  qwerty àèìòù<br>
                  -----------------<br>
                </div>
              </div>
            </div>
            <br>
            _______________________________________________<br>
            <a moz-do-not-send="true" href="mailto:Gfoss@lists.gfoss.it">Gfoss@lists.gfoss.it</a><br>
            <a moz-do-not-send="true"
              href="http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss"
              target="_blank">http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss</a><br>
            Questa e' una lista di discussione pubblica aperta a tutti.<br>
            I messaggi di questa lista non hanno relazione diretta con
            le posizioni dell'Associazione GFOSS.it.<br>
            666 iscritti al 22.7.2013<br>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
  </body>
</html>