<!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><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"><SPAN
class=096354507-22102012>Hello</SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"><SPAN
class=096354507-22102012></SPAN></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"><SPAN
class=096354507-22102012>
<DIV><SPAN class=096354507-22102012>"</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
class=096354507-22102012>"</SPAN></DIV>
<DIV><SPAN class=096354507-22102012></SPAN> </DIV>
<DIV><SPAN class=096354507-22102012><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 class=096354507-22102012><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=096354507-22102012><FONT
color=#0000ff>Hugues.</FONT></SPAN></DIV></SPAN></SPAN></DIV>
<DIV> </DIV><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
09:25<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>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><BR>
<DIV>INSERT INTO geometry_columns (f_table_catalog,f_table_schema, f_table_name,
f_geometry_column, coord_dimension, srid,type)Â </DIV>
<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>in both cases table permanent.</DIV>
<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 class=gmail_quote>2012/10/22 Sandro Santilli [via PostGIS] <SPAN
dir=ltr><<A href="/user/SendEmail.jtp?type=node&node=5000685&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 class=im>On Mon, Oct 22, 2012 at 08:40:07AM +0200, Pietro Rossin wrote:
<BR><BR></DIV>
<DIV class=im>> DELETE FROM geometry_columns WHERE f_table_name =
'puntigronda'; <BR></DIV>
<DIV class=im>... <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 class=im>--strk; <BR><BR>Â <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>_______________________________________________ <BR>postgis-users
mailing list <BR></DIV><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 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-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 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></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-tp5000570p5000685.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>