<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:odc="urn:schemas-microsoft-com:office:odc" 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:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" 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:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" 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:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" 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)">
<title>FDOPostGIS 3.4L Check In of New generated PointFeature causes
ErrorMessage</title>
<style>
<!--
/* Font Definitions */
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{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-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Hermann,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The problem with the insert using Map3D seems to be not with the
actual insert, but with the retrieval of the generated gid value after the
insert. Reading the generated gid value from the feature reader returned by the
provider for the insert command is failing.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Orest.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
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 style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Hermann Karl<br>
<b>Sent:</b> Tuesday, August 11, 2009 3:53 AM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] FDOPostGIS 3.4L Check In of New generated
PointFeature causes ErrorMessage<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Dear
List, </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I
tested FDO-Insert on the data from the previous message (gid PRIMARY KEY
SERIAL) with FDO Toolbox </span><a href="http://fdotoolbox.googlecode.com"><span
lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>http://fdotoolbox.googlecode.com</span></a><span
lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'> from
Jackie Ng and the Providers FDOPostGIS 3.4L from geomapgis and FDOPostGIS 3.4.0
from OSGEO.</span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>!!!!!
I did not have any problems to insert a new feature. !!!!!</span><span
lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>!!!!!
It seems that there is a serious problem of AutoCAD Map 3d 2010 with the
FDOPostGIS Provider 3.4 !!!!!.</span><span lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I
have tested the proposed "workaround" from David Anderson</span><span
lang=DE-AT> </span><a
href="http://lists.osgeo.org/pipermail/fdo-users/attachments/20090716/a22481f5/postgistable.obj"><span
lang=DE-AT style='font-size:10.0pt;font-family:"Courier New"'>http://lists.osgeo.org/pipermail/fdo-users/attachments/20090716/a22481f5/postgistable.obj</span></a><span
lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'> with FDO
Toolbox and it works too.</span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>--
create sequence --</span><span lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>CREATE
SEQUENCE public.blocktest5_gid_seq</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
INCREMENT 1</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
MINVALUE 1</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
MAXVALUE 9223372036854775807</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
START 1</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
CACHE 1;</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>ALTER
TABLE public.blocktest5_gid_seq OWNER TO postgres;</span><span lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>--
create function --</span><span lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>CREATE
OR REPLACE FUNCTION public.autoinc_blocktest5_gid_trig()</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
RETURNS trigger AS</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>$BODY$</span>
<br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>declare</span>
<br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>begin</span>
<br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>select
nextval('public.blocktest5_gid_seq') into new.gid;</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>return
new;</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>end;</span>
<br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>$BODY$
LANGUAGE plpgsql VOLATILE;</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>--
COST 100;</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>ALTER
FUNCTION public.autoinc_blocktest5_gid_trig() OWNER TO postgres;</span><span
lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>--
create table --</span><span lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>CREATE
TABLE "blocktest5" ("gid" int PRIMARY KEY DEFAULT 1,</span>
<br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>"blockname"
varchar(255),</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>"layer"
varchar(255),</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>"rotation"
numeric,</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>"s"
varchar(255),</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>"u"
varchar(255));</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>SELECT
AddGeometryColumn('','blocktest5','the_geom','-1','POINT',2);</span><span
lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>--
create trigger --</span><span lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>CREATE
TRIGGER autoinc_blocktest5_gid</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
BEFORE INSERT</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
ON public.blocktest5</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
FOR EACH ROW</span> <br>
<span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
EXECUTE PROCEDURE public.autoinc_blocktest5_gid_trig();</span><span lang=DE-AT>
</span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>--
insert points --</span><span lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>INSERT
INTO "blocktest5"
("blockname","layer","rotation","s","u",the_geom)
VALUES
('GN1','GN','0.000000000000000','789',NULL,'0101000000FDA08A2C9FB3E3C0B9770762A8FA0E41');</span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>INSERT
INTO "blocktest5"
("blockname","layer","rotation","s","u",the_geom)
VALUES ('GN2','GN','0.000000000000000','2345','6','0101000000E54B15C275B3E3C053379F6D81F90E41');</span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Any
comments from autodesk ?</span><span lang=DE-AT> </span><o:p></o:p></p>
<p><span lang=DE-AT style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Karl</span><span
lang=DE-AT> </span><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br>
<br>
<o:p></o:p></p>
</div>
</body>
</html>