<!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 8.00.6001.19328"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143424309-22102012>Your view is defined by a sql select so you should try
to leave this select as is except for the where clause where you could add
something like : and c.relname not like 'your_table_name'</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143424309-22102012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143424309-22102012>I tried it with one of my table and this was ok, the
table disappeared from the geometry_columns view</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143424309-22102012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=143424309-22102012>Hugues.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT> </DIV><FONT
color=#0000ff size=2 face=Arial></FONT><BR>
<DIV dir=ltr lang=fr class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>De :</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>De la part de</B>
Pietro Rossin<BR><B>Envoyé :</B> lundi 22 octobre 2012
11:40<BR><B>À :</B>
postgis-users@postgis.refractions.net<BR><B>Objet :</B> Re: [postgis-users]
How to make some geometry column visible to Qgis<BR></FONT><BR></DIV>
<DIV></DIV>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"
rel=nofollow target=_top link="external">[hidden email]</A>></SPAN><BR>
<BLOCKQUOTE
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 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 target=_blank link="external">[hidden email]</A> [mailto:<A
href="http://user/SendEmail.jtp?type=node&node=5000686&i=1"
rel=nofollow target=_blank link="external">[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 target=_blank link="external">[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 target=_blank link="external">[hidden email]</A>></SPAN><BR>
<BLOCKQUOTE
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
target=_blank link="external">http://www.cartodb.com</A>Â - Map,
analyze and build applications with your data <BR><BR>Â Â
        Â
         ~~ <A
href="http://strk.keybit.net" rel=nofollow target=_blank
link="external">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 target=_blank link="external">[hidden email]</A> <BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
rel=nofollow target=_blank
link="external">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 target=_blank
link="external">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 target=_top link="external">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 target=_blank link="external">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 target=_blank link="external">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
target=_blank link="external">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 target=_blank link="external">[hidden email]</A> <BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
rel=nofollow target=_blank
link="external">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR><BR>
<HR color=#cccccc SIZE=1 noShade>
</DIV>
<DIV style="FONT: 12px tahoma,geneva,helvetica,arial,sans-serif; COLOR: #444">
<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"
rel=nofollow target=_blank
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="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 href=""
rel=nofollow target=_blank link="external">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 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></BODY></HTML>