<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" 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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-CA link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>This is all good news. It’s
great to see the PostGIS provider maturing.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>For the previous 3.2 binary release
of the provider, I just pulled down the 3.3 trunk version into a local 3.2 tree
and built it. I may have had to change a couple things, but I don’t
think so. Bruno, would you be willing to do this for 3.2, or should we
look at having the OSGeo SAC set up yet another repository for us? Greg,
how are you handling this for the SQL 2008 provider? It would be nice if
the 3.2 repositories could eventually be archived and taken offline, but given
that most of the live implementations of FDO are still using 3.2, it will take
a while until we get to that point.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I’m not sure how Mateusz
feels about this, but I think that if the first few of Bruno’s patches
look good that it would be more efficient for him to be given commit access,
and for Mateusz (or others) to do post-commit review.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I’m assuming that we have
received Bruno’s contribution agreements?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Jason<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Greg Boone<br>
<b>Sent:</b> Friday, April 04, 2008 13:29<br>
<b>To:</b> Bruno Scott<br>
<b>Cc:</b> FDO Internals Mail List<br>
<b>Subject:</b> [fdo-internals] RE: FDO OSGeo PostGIS Provider<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Hi Bruno,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Thanks for the
update. </span><span lang=EN-US style='font-family:Wingdings;color:#1F497D'>J</span><span
lang=EN-US style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><u><span lang=EN-US style='color:#1F497D'>For 3.3/3.4</span></u><span
lang=EN-US style='color:#1F497D'>, Submit your changes into <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>3.4 -- <a
href="https://svn.osgeo.org/fdo/trunk/Providers/PostGIS">https://svn.osgeo.org/fdo/trunk/Providers/PostGIS</a><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>3.3 -- <a
href="https://svn.osgeo.org/fdo/branches/3.3/Providers/PostGIS">https://svn.osgeo.org/fdo/branches/3.3/Providers/PostGIS</a><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Please have Mateusz
review and if needed, submit those submissions<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><u><span lang=EN-US style='color:#1F497D'>For 3.2.x <o:p></o:p></span></u></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>This is a trickier
issue. We do not have a SVN repository available for PostGIS built on 3.2.x. We
could create a new SVN repository that follows the existing 3.2.x pattern as
described on <a href="http://fdo.osgeo.org/roadMap.html">http://fdo.osgeo.org/roadMap.html</a><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>This repository name
would be: <a href="http://svn.osgeo.org/fdopostgis/branches/3.2.x">http://svn.osgeo.org/fdopostgis/branches/3.2.x</a><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>You would need Jason
or Frank to help you with this.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Once all the
submissions are in, we can kick off the respective 3.2.x and 3.3.x builds and
post patches on fdo.osgeo.org.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Greg<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> Bruno Scott [mailto:Bruno@geomapgis.com] <br>
<b>Sent:</b> Friday, March 28, 2008 7:30 AM<br>
<b>To:</b> Greg Boone<br>
<b>Cc:</b> Gwenael Bachelot<br>
<b>Subject:</b> RE: FDO OSGeo PostGIS Provider<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Hi Greg<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>We have still a
couple issues with the PostGIS Driver<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/94"
title="Generate extent for features assigned to default spatial context">#94</a>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Generate extent for features
assigned to default spatial context<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
We’re going to check that one<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/106"
title="PostGIS provider cannot delete a feature class">#106</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>PostGIS provider cannot
delete a feature class<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Deleting works with feature class and non feature class<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
But the table must be empty<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/117"
title="PostGIS provider does not display attribute names in MapGuide when no PK ...">#117</a>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>PostGIS provider does
not display attribute names in MapGuide when no PK present<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:#548DD4'>This is a normal
behavior<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#17365D'>
<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/171"
title="Fdo Postgis Autogenated identity property is mandatory">#171</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis Autogenated
identity property is mandatory<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Not mandatory anymore<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/178"
title="PostGIS : Can't insert in a non-feature class">#178</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>PostGIS : Can't insert
in a non-feature class<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Non-feature class works well with insert,delete,update and for displaying with
join<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/232"
title="Fdo Postgis null and not null filter does not work">232</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis null and not
null filter does not work<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Not yet implemented, I will add this one in our unit tests<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/233"
title="Fdo Postgis in and not in filter does not work">#233</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis in and not
in filter does not work<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
fixed<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/234"
title="Fdo Postgis currently does not support anything but lowercase identifiers">234</a>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis currently
does not support anything but lowercase identifiers<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:#548DD4'>Still some pending
problems with that one<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/235"
title="Fdo Postgis Exception with insert">#235</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis Exception
with insert<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
fixed<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/236"
title="Fdo Postgis does not support non spatial classes">#236</a> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Fdo Postgis does not
support non spatial classes<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
fixed<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:black'><a href="http://trac.osgeo.org/fdo/ticket/241"
title="Implement Support for SelectAggregates, SpatialExtents and Count">#241</a>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:black'>Implement Support for SelectAggregates,
SpatialExtents and Count<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Select Count works fine now, so selectAggregates also<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
Nothing was implemented<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>
More testing should be done<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>Other things, there was
a discussion with the community according to the class naming convention<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'>So we have fallow the
community recommendation and we have replaces the “shema~class” by
“class” only.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>We ran our test in
different environments<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>
100% FDO / C++ program ( without any map or Mapguide)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>
Map 2008 / fdo 3.2<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>
Map 2009 / fdo 3.3<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>
Mapguide 1.2 / fdo 3.2<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>
Mapguide 2.0 / fdo 3.3<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Using the same
Postgres/PostGIS version as Matheus ( 8.2.4 + 1.2.1)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>We have 3 primary
spatial tables with all the same columns (one for point, one for
line/multi-line and one for polygon/multi-polygon)<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>KEY_1
Int32<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>STRING_1
String<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>INT32_1
Int32<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>DOUBLE_1
Double<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>DATE_1
DateTime<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>STR_CODE_1
String 64<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>INT_CODE_1
Int32<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>GEOMETRY_1
GEOMETRY<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>plus one primary
alpha table (without geometry)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>and one primary X/Y
table ( Postgis provider does not support displaying it YET)<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>We have one secondary
alpha table for 1-1 joining ( KEY_1 = j_KEY_1) with the 5 primary tables<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>J_KEY_1
Int32
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>J_STRING_1
String
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>J_INT32_1
Int32
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>J_DOUBLE_1
Double
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>J_DATE_1
DateTime
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>J_STR_CODE_1
String
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>J_INT_CODE_1
Int32<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>We have two secondary
alpha table for n-1 joining (INT_CODE_1 = INT_CODE_1 / STR_CODE_1 = STR_CODE_1)
with the 5 primary tables<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>INT_CODE_1
Int32
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=FR style='color:#1F497D'>DESC_1
String <o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>And<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>STR_CODE_1
String<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span lang=EN-US style='color:#1F497D'>DESC_1
String<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><span lang=EN-US style='color:#1F497D'>Unit test
with FDO/C++ ( all test succeed, 0 failed)<o:p></o:p></span></b></p>
<p class=MsoNormal><b><span lang=EN-US> Schema modification<o:p></o:p></span></b></p>
<p class=MsoNormal><span lang=EN-US>
Drop spatial table ( failed if data in the table)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Drop non-spatial table ( failed if data in the table)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Create spatial table<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Create non-spatial table<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> All our test table are
dropped and recreated using FDO prior doing any other test<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US
style='font-size:10.0pt'> Alpha Filter test<o:p></o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Using <o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>FdoCommandType_Select (select column from
… )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>FdoCommandType_SelectAggregates ( select
Count(1) from … )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>FdoCommandType_SQLCommand ( complexe query
with 1-1 / n-1 joins )<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Key = 1<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Key In (1,2)<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Key Not In (1,2)<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Key > 99<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Key >= 99<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Key < 2<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Key <= 2<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> String = 'Bb'<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> String In ('Bb','Dd')<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> String Not In ('Bb','Dd')<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> String Like 'B%'<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> String Not Like 'B%'<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> </span><span lang=FR
style='font-size:10.0pt'>Int = 10010<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Int > 10990<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Int >= 10990<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Int < 10020<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Int <= 10020<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double = 20010.0000001<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double > 118010.0097903<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double >= 118010.0097903<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double < 21010.0001<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Double <= 21010.0001<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> Date = 2007-01-01<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=FR style='font-size:
10.0pt'> </span><span lang=EN-US style='font-size:10.0pt'>Date
> 2007-04-09<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Date >= 2007-04-09<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Date < 2007-01-02<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Date <= 2007-01-02<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> DateTime = 2007-01-01 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> DateTime > 2007-04-09 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> DateTime >= 2007-04-09 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> DateTime < 2007-01-02 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> DateTime <= 2007-01-02 00:00:00<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US
style='font-size:10.0pt'> Spatial Filter test<o:p></o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'> Using <o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>FdoCommandType_Select (select column from
… )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>FdoCommandType_SelectAggregates ( select
Count(1) from … )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>FdoCommandType_SQLCommand ( complexe query
with join )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>geometry ENVELOPEINTERSECTS GeomFromText('POLYGON
XY …')"<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>geometry ENVELOPEINTERSECTS
GeomFromText(POINT XY …')"<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>we didn’t test the LINESTRING ( we
should )<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US
style='font-size:10.0pt'> Update test<o:p></o:p></span></b></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'>
Insert simple polygon<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'>
Insert multi polygon<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'>
Insert polygon with hole<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>Insert linestring<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>Insert multi linestring<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Insert point<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Insert alpha ( no geometry in table)<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
style='font-size:10.0pt'>
Delete polygon<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt'>Delete linestring<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
</span><span lang=EN-US style='font-size:10.0pt'>Delete </span><span
lang=EN-US>point<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
</span><span lang=EN-US style='font-size:10.0pt'>Delete </span><span
lang=EN-US>alpha ( no geometry in table)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update int32 ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update String ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update double ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update date ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update datetime ( on spatial and non-spatial table)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update geometry simple polygon<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update geometry multi polygon<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update geometry polygon with hole<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update geometry linestring<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update geometry multi linestring<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>
Update geometry point<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Test with Map 2008<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Connecting OK<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Attaching table with srid OK <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Attaching table without srid -> map display a warning<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Display point ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Display linestring ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Display polygon ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Joining spatial table to non-spatial table ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Table view display ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Updating in the table view ok but the check-in crashes map<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Check-out crashes map<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Test with Map 2009<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
This after noon<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Test with Mapguide 1.2<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Everything seems ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
But still some testing to do with srid<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Test with Mapguide 2.0<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
Everything seems ok<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
But still some testing to do with srid<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>We are actually investigating on the crash
problem within map 2008.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>I don’t know exactly what are the
process to submit all our code changes with the release 3.2.2 and 3.3.0.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>If you could provide some help on that
point it will be appreciated.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Cheers<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Bruno<o:p></o:p></span></p>
<p class=MsoNormal><b><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></b></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt'>From:</span></b><span
lang=EN-US style='font-size:10.0pt'> Greg Boone
[mailto:greg.boone@autodesk.com] <br>
<b>Sent:</b> jeudi 27 mars 2008 18:29<br>
<b>To:</b> Bruno Scott (External)<br>
<b>Subject:</b> FDO OSGeo PostGIS Provider<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Hi Bruno,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>I was wondering if you could provide an
update on the status of the FDO OSGeo PostGIS Provider modifications that your
team has been working on?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>What changes have been made so far and how
do these relate to the FDO Track issues that have been logged?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>What is your plan to submit changes to the
FDO OSGeo SVN?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>When can your changes be rolled into our
formalized build process and released as an official patch to the FDO 3.3
release?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Will you changes also support FDO 3.2? <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>If so, we need to get that the FDO 3.2 code
dropped as well, and an official provider release posted.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Cheers,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Greg<o:p></o:p></span></p>
</div>
</body>
</html>