<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" 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)">
<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;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
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'>Hi,<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 need to create a number of spatial tables and have written
a script to achieve this.<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 been having lots of problems with
AddGeometryColumn function not working, firstly it wouldn’t recognise the
correct number of parameters, I got around this by putting in all the optional parameters
and prefixing the function with <b><span style='font-weight:bold'>public.</span></b>
However now it doesn’t recognise the <b><span style='font-weight:bold'>geometry</span></b>
data type – however if I run the same command in psql its fine –
any ideas?<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'>Thanks<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'>Steve<o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=1 face=Arial><span style='font-size:8.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig><font size=1 face=Arial><span style='font-size:8.0pt;
font-family:Arial'>_________________________________________________________________<o:p></o:p></span></font></p>
<p class=MsoAutoSig><b><font size=1 face=Arial><span style='font-size:8.0pt;
font-family:Arial;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoAutoSig><b><font size=1 face=Arial><span style='font-size:8.0pt;
font-family:Arial;font-weight:bold'>Steve Davies<o:p></o:p></span></font></b></p>
<p class=MsoAutoSig><font size=1 color=gray face=Arial><span style='font-size:
8.0pt;font-family:Arial;color:gray'>Software Engineer, Development Team, Dotted
Eyes Ltd<o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=1 face=Arial><span style='font-size:8.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig><font size=1 face=Arial><span style='font-size:8.0pt;
font-family:Arial'>Switchboard: +44(0)1527 556920<o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=1 face=Arial><span style='font-size:8.0pt;
font-family:Arial'>Email: <font color=gray><span style='color:gray'><a
href="steve.davies@dottedeyes.com"><font color=gray><span style='color:gray'>steve.davies@dottedeyes.com</span></font></a><o:p></o:p></span></font></span></font></p>
<p class=MsoAutoSig><font size=1 face=Arial><span style='font-size:8.0pt;
font-family:Arial'>_________________________________________________________________<o:p></o:p></span></font></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>
<p>
<SPAN style="FONT-SIZE: 8.5pt; FONT-FAMILY: Arial"><B>Simplify. Automate. Integrate.<BR/><BR/>Dotted Eyes</B>
</SPAN>
<SPAN style="COLOR: gray; FONT-FAMILY: Arial">
<FONT style="FONT-SIZE: 8.5pt"><BR />
</FONT>
</SPAN>
<SPAN style="FONT-SIZE: 8.5pt; COLOR: gray; FONT-FAMILY: Arial">Hanbury Court, Harris Business Park,<BR />
Stoke Prior, Bromsgrove, B60 4JJ, UK<BR />
</SPAN><br />
<SPAN style="FONT-FAMILY: Arial"><b><font style="FONT-SIZE: 8.5pt">New! OS OpenData - free datasets</font></b><br />
<FONT style="FONT-SIZE: 8.5pt"><a href="http://www.dottedeyes.com/opendata">Visit our OS OpenData page for details</a></FONT></FONT></SPAN></p><p>
<SPAN style="FONT-FAMILY: Arial"><b><font style="FONT-SIZE: 8.5pt">Join us at seminars and exhibitions</font></b><br />
<FONT style="FONT-SIZE: 8.5pt"><a href="http://www.dottedeyes.com/events/index.php">View our event calendar</a></FONT></FONT></SPAN></p><p>
<p>
<SPAN style="FONT-FAMILY: Arial"><b><font style="FONT-SIZE: 8.5pt">Buy training, support and SuperpOSe Service online</font></b><br /><p>
<FONT style="FONT-SIZE: 8.5pt"><a href="http://www.dottedeyes.com">Visit our website</a></FONT></FONT></SPAN></p>
<DIV style="COLOR: gray; FONT-FAMILY: Arial; FONT-SIZE: 8.5pt;">
ResponseMX dynamic web maps:
<A style="text-underline: single" href="http://www.dottedeyes.com/rmx">
<FONT color="#808080">www.dottedeyes.com/rmx</FONT>
</A>
</DIV>
<DIV style="COLOR: gray; FONT-FAMILY: Arial; FONT-SIZE: 8.5pt;">
Spatial data loading:
<A style="text-underline: single" href="http://www.dottedeyes.com/spatial">
<FONT color="#808080">www.dottedeyes.com/spatial</FONT>
</A>
</DIV>
<DIV style="COLOR: gray; FONT-FAMILY: Arial; FONT-SIZE: 8.5pt;">
Ready-to-use digital maps & data:
<A style="text-underline: single" href="http://www.dottedeyes.com/data">
<FONT color="#808080">www.dottedeyes.com/data</FONT>
</A>
</DIV>
<DIV style="COLOR: gray; FONT-FAMILY: Arial; FONT-SIZE: 8.5pt;">
For a sales enquiry email:
<A style="text-underline: single" href="mailto:sales@dottedeyes.com">
<FONT color="#808080">sales@dottedeyes.com</FONT>
</A></DIV>
<DIV style="COLOR: gray; FONT-FAMILY: Arial; FONT-SIZE: 8.5pt;">
For technical support login to:
<A style="text-underline: single" href="http://dottedeyes.helpserve.com">
<FONT color="#808080">http://dottedeyes.helpserve.com</FONT>
</A>
</DIV>
<BR />
</FONT> </SPAN>
<SPAN style="FONT-SIZE: 8.5pt; COLOR: gray; FONT-FAMILY: Arial">
Dotted Eyes Ltd is registered in England and Wales, reg no 4471760.<BR />
This email may contain confidential information, not to be disclosed.<BR />
Contents are personal and not necessarily the views of Dotted Eyes.<BR />
Emails and attachments may be monitored without notice in advance. </SPAN>
<SPAN style="COLOR: gray; FONT-FAMILY: Arial">
<FONT style="FONT-SIZE: 8.5pt"><BR />
<BR />
</FONT> </SPAN>
<SPAN style="COLOR: gray; FONT-FAMILY: Arial">
<FONT style="FONT-SIZE: 8.5pt">
<A href="http://www.altman.co.uk/emailsystems/"><FONT color="#808080">Email has been scanned for viruses and spam by Altman Technologies</FONT></A></FONT> </SPAN> </p>
</DIV></body>
</html>