Hello Hugues<div>in my database I have both views and a main table on which these views pick data from.</div><div>All of them have their own geometry column registered into the geometry column set by postgis</div><div><br>
</div><div>My problem is that the main table (a huge one with mixed geometry data type) has its own geometry column.</div><div>When qgis starts the connection to this db automatically looks into the geometry column set and find the geom.column relative to the main table, so it searches that table for the geometry type and take a lot of time to do it...</div>
<div><br></div><div>How can I hide this geometry column?<br><br>Thnx</div><div>Pietro<br><br><div class="gmail_quote">2012/10/22 Francois Hugues [via PostGIS] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=5000687&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>></span><br>
<blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" align="left"><span style="FONT-FAMILY:Arial;FONT-SIZE:10pt"><span>Hello</span></span></div>
<div dir="ltr" align="left"><span style="FONT-FAMILY:Arial;FONT-SIZE:10pt"><span></span></span> </div>
<div dir="ltr" align="left"><span style="FONT-FAMILY:Arial;FONT-SIZE:10pt"><span><div class="im">
<div><span>"</span>This because I cannot remove the
entities geometry column unless I remove the entity table first.</div>
<div>And if I don't remove (or make invisible to qgis if possible) the entities
geometry column it slow down the qgis connection.<span>"</span></div>
<div><span></span> </div>
</div><div class="im"><div><span><font color="#0000ff">Did you try to edit the
view, using the where clause to exclude the tables you don't want to be seen by
postgis ?</font></span></div>
<div><span><font color="#0000ff"></font></span> </div>
<div><span><font color="#0000ff">Hugues.</font></span></div></div></span></span></div>
<div> </div><br>
<div dir="ltr" lang="fr" align="left">
<hr>
<font face="Tahoma"><b>De :</b>
<a href="http://user/SendEmail.jtp?type=node&node=5000686&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>
[mailto:<a href="http://user/SendEmail.jtp?type=node&node=5000686&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a>] <b>De la part de</b>
Pietro Rossin<div class="im"><br><b>Envoyé :</b> lundi 22 octobre 2012
09:25<br></div><b>À :</b>
<a href="http://user/SendEmail.jtp?type=node&node=5000686&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a><br><b>Objet :</b> Re: [postgis-users]
How to make some geometry column visible to Qgis<br></font><br></div><div class="im">
<div></div>DELETE FROM geometry_columns WHERE f_table_name = 'puntigronda';
<div><br></div>
<div>Query returned successfully: 0 rows affected, 0 ms execution time.</div>
</div><div><br>
<div>INSERT INTO geometry_columns (f_table_catalog,f_table_schema, f_table_name,
f_geometry_column, coord_dimension, srid,type)Â </div><div class="im">
<div>Â VALUES ('','', 'puntigronda', 'the_geom', 3, 3004,'POINTS');</div>
<div><br></div>
<div>Query returned successfully: 0 rows affected, 16 ms execution time.</div>
<div><br></div>
<div>select relkind from pg_class where relname = 'geometry_columns';</div>
<div><br></div>
<div>returns:</div>
<div>"v"</div>
<div><br></div>
<div>What is this?</div>
<div><br></div>
<div>By the way</div>
<div>If my technique works, is it still better to explode the "entities" table
in one of this cases:</div>
<div><br></div>
<div>a) single layers</div>
<div>b) same kind of geometries</div>
<div><br></div>
</div><div>in both cases table permanent.</div><div class="im">
<div><br></div>
<div>This because I cannot remove the entities geometry column unless I remove
the entity table first.</div>
<div>And if I don't remove (or make invisible to qgis if possible) the entities
geometry column it slow down the qgis connection.</div>
<div><br></div>
<div>Thanks for your help</div>
<div>Pietro</div>
<div><br></div>
</div><div class="gmail_quote">2012/10/22 Sandro Santilli [via PostGIS] <span dir="ltr"><<a href="http://user/SendEmail.jtp?type=node&node=5000685&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>></span><br>
<blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' style="BORDER-LEFT:#cccccc 2px solid;PADDING-BOTTOM:0px;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1em;PADDING-RIGHT:1em;PADDING-TOP:0px" class="gmail_quote"><div class="im">
<div>On Mon, Oct 22, 2012 at 08:40:07AM +0200, Pietro Rossin wrote:
<br><br></div>
<div>> DELETE FROM geometry_columns WHERE f_table_name =
'puntigronda'; <br></div>
<div>... <br>> Is there something wrong? <br><br>What's wrong is
that the "geometry_columns" table should be a view, <br>in PostGIS-2.0. If it
is a view, your DELETE and INSERT and UPDATE <br>to it should have no effect.
<br><br>Can you verify this first ? <br>The DELETE/INSERT/UPDATE commands all
return the number of affected <br>rows. If PostGIS is correctly installed you
should alwyas get 0, <br>no matter what you try to insert/delete/update.
<br><br>Also check: <br>select relkind from pg_class where relname =
'geometry_columns'; <br><br></div>
</div><div>--strk; <br><br><div class="im">Â <a href="http://www.cartodb.com" rel="nofollow" link="external" target="_blank">http://www.cartodb.com</a>Â -
Map, analyze and build applications with your data <br><br>Â Â
        Â
         ~~ <a href="http://strk.keybit.net" rel="nofollow" link="external" target="_blank">http://strk.keybit.net</a>Â
<br><br></div>_______________________________________________ <br>postgis-users
mailing list <br></div><div class="im"><a href="http://user/SendEmail.jtp?type=node&node=5000684&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a> <br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br><br>
<hr color="#cccccc" size="1" noshade>
<div style="FONT:12px tahoma,geneva,helvetica,arial,sans-serif;COLOR:#444">
<div>
<div style="FONT-WEIGHT:bold">If you reply to this email, your message will
be added to the discussion below:</div></div><a href="http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000684.html" rel="nofollow" link="external" target="_blank">http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000684.html</a>
</div>
<div style="MARGIN-TOP:0.4em;FONT:11px/1.5em tahoma,geneva,helvetica,arial,sans-serif;COLOR:#666">To
unsubscribe from How to make some geometry column visible to Qgis, <a rel="nofollow" link="external" target="_top">click here</a>.<br><a style="FONT:9px serif" href="http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" link="external" target="_blank">NAML</a>
</div></div></blockquote></div><br></div><div class="im"><br>
<hr align="left" width="300">
View this message in context: <a href="http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000685.html" rel="nofollow" link="external" target="_blank">Re:
How to make some geometry column visible to Qgis</a><br>Sent from the <a href="http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html" rel="nofollow" link="external" target="_blank">PostGIS - User
mailing list archive</a> at Nabble.com.<br>
<br></div><div class="im">_______________________________________________
<br>postgis-users mailing list
<br><a href="http://user/SendEmail.jtp?type=node&node=5000686&i=3" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<hr noshade size="1" color="#cccccc">
</div><div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif"><div class="im">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
</div><a href="http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000686.html" target="_blank" rel="nofollow" link="external">http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000686.html</a>
</div><div class="HOEnZb"><div class="h5">
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from How to make some geometry column visible to Qgis, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
</div></div></div></blockquote></div><br></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000687.html">Re: How to make some geometry column visible to Qgis</a><br/>
Sent from the <a href="http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html">PostGIS - User mailing list archive</a> at Nabble.com.<br/>