<div><div><div>Sandro, According to the chapter 4.3.2 of the postgis 2.0.1 manual (page 31) you're right..</div><div><br></div><div>So, I'll use the addgeometrycolumn() function to handle geometry columns, but..</div>
<div><br></div><div>May be that the technique I used before is a bug in postgis??</div><div><br></div><div>Bye</div></div><div>Pietro</div><div><br></div><div class="gmail_quote">2012/10/22 Sandro Santilli [via PostGIS] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=5000714&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 class="im">

        On Mon, Oct 22, 2012 at 02:39:31AM -0700, Pietro Rossin wrote:
<br><br></div><div class="im">> My problem is that the main table (a huge one with mixed geometry data
<br>> type) has its own geometry column.
<br>> When qgis starts the connection to this db automatically looks into the
<br>> geometry column set and find the geom.column relative to the main table, so
<br>> it searches that table for the geometry type and take a lot of time to do
<br>> it...
<br>> 
<br>> How can I hide this geometry column?
<br><br></div><div class="im">You can tell QGis to "only look in geometry_columns" (which became
<br>"only look in layer registries" in current development version).
<br><br>It's a configuration of the PostgreSQL connection.
<br><br>--strk;
<br><br></div> <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><div class="im"><br>_______________________________________________
<br>postgis-users mailing list
<br><a href="http://user/SendEmail.jtp?type=node&node=5000690&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 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-tp5000570p5000690.html" target="_blank" rel="nofollow" link="external">http://postgis.17.n6.nabble.com/How-to-make-some-geometry-column-visible-to-Qgis-tp5000570p5000690.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-tp5000570p5000714.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/>