<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m fairly new to Postgis so am finding my feet
gradually.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’ve created a view on a spatial table and added a
line into the geometry_columns table to reference the view. The problem I’ve
got is trying to pass on to the client (in my case Cadcorp GIS system)
information about a spatial index. I know that a view is essentially an ‘on
the fly’ reconstruction of a query on a table but is there any way to associate
a spatial index with a view?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=green face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:green'>James Rutter</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=1 color=silver face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:silver'>GIS Manager</span></font><o:p></o:p></p>
<p class=MsoNormal><st1:place w:st="on"><font size=1 color=silver face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:silver'>Surrey</span></font></st1:place><font
size=1 color=silver face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:silver'> Heath Borough Council</span></font><o:p></o:p></p>
<p class=MsoNormal><st1:place w:st="on"><font size=1 color=silver face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:silver'>Surrey</span></font></st1:place><font
size=1 color=silver face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:silver'> Heath House</span></font><o:p></o:p></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=1
color=silver face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:silver'>Knoll Road</span></font></st1:address></st1:Street><o:p></o:p></p>
<p class=MsoNormal><font size=1 color=silver face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:silver'>Camberley</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=1 color=silver face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:silver'>GU15 3HD</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=1 color=silver face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:silver'>Tel: 01276 707200</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=1 color=silver face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:silver'>Fax: 01276 707516</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<DIV> </DIV>
<DIV>
<HR>
This email and any attachments are intended for the addressee only. The
information contained in this email is confidential and may be legally
privileged. If you are not the intended recipient, the use of the information
contained in this email or any disclosure, copying or distribution is prohibited
and may be unlawful. If you have received this email in error please notify
the sender or <A
href="mailto:mailadmin@surreyheath.gov.uk">mailadmin@surreyheath.gov.uk</A></DIV>
<DIV> </DIV>
<DIV></DIV>
<DIV>Surrey Heath Borough Council reserves the right to monitor all incoming and
outgoing email to ensure compliance with current procedures. This email has been
checked for computer viruses prior to sending, but it is also your
responsibility to virus check the email upon receipt.</DIV>
<DIV> </DIV>
<DIV><A href="http://www.surreyheath.gov.uk">www.surreyheath.gov.uk</A><BR>
<HR>
</DIV>
</body>
</html>