<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>FDOPostGIS 3.4L Check In of New generated PointFeature causes ErrorMessage</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Dear List, </FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">I tested FDO-Insert on the data from the previous message (gid PRIMARY KEY SERIAL) with FDO Toolbox </FONT></SPAN><A HREF="http://fdotoolbox.googlecode.com"><SPAN LANG="de-at"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://fdotoolbox.googlecode.com</FONT></U></SPAN></A><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> from Jackie Ng and the Providers FDOPostGIS 3.4L from geomapgis and FDOPostGIS 3.4.0 from OSGEO.</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">!!!!! I did not have any problems to insert a new feature. !!!!!</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">!!!!! It seems that there is a serious problem of AutoCAD Map 3d 2010 with the FDOPostGIS Provider 3.4 !!!!!.</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">I have tested the proposed "workaround" from David Anderson</FONT> </SPAN><A HREF="http://lists.osgeo.org/pipermail/fdo-users/attachments/20090716/a22481f5/postgistable.obj"><SPAN LANG="de-at"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Courier New">http://lists.osgeo.org/pipermail/fdo-users/attachments/20090716/a22481f5/postgistable.obj</FONT></U></SPAN></A><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> with FDO Toolbox and it works too.</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- create sequence --</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">CREATE SEQUENCE public.blocktest5_gid_seq</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> INCREMENT 1</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> MINVALUE 1</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> MAXVALUE 9223372036854775807</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> START 1</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> CACHE 1;</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">ALTER TABLE public.blocktest5_gid_seq OWNER TO postgres;</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- create function --</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">CREATE OR REPLACE FUNCTION public.autoinc_blocktest5_gid_trig()</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> RETURNS trigger AS</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">$BODY$</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">declare</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">begin</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">select nextval('public.blocktest5_gid_seq') into new.gid;</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">return new;</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">end;</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">$BODY$ LANGUAGE plpgsql VOLATILE;</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- COST 100;</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">ALTER FUNCTION public.autoinc_blocktest5_gid_trig() OWNER TO postgres;</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- create table --</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">CREATE TABLE "blocktest5" ("gid" int PRIMARY KEY DEFAULT 1,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"blockname" varchar(255),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"layer" varchar(255),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"rotation" numeric,</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"s" varchar(255),</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">"u" varchar(255));</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">SELECT AddGeometryColumn('','blocktest5','the_geom','-1','POINT',2);</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- create trigger --</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">CREATE TRIGGER autoinc_blocktest5_gid</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> BEFORE INSERT</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> ON public.blocktest5</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> FOR EACH ROW</FONT></SPAN>
<BR><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial"> EXECUTE PROCEDURE public.autoinc_blocktest5_gid_trig();</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">-- insert points --</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">INSERT INTO "blocktest5" ("blockname","layer","rotation","s","u",the_geom) VALUES ('GN1','GN','0.000000000000000','789',NULL,'0101000000FDA08A2C9FB3E3C0B9770762A8FA0E41');</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">INSERT INTO "blocktest5" ("blockname","layer","rotation","s","u",the_geom) VALUES ('GN2','GN','0.000000000000000','2345','6','0101000000E54B15C275B3E3C053379F6D81F90E41');</FONT></SPAN></P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Any comments from autodesk ?</FONT></SPAN>
</P>
<P><SPAN LANG="de-at"><FONT SIZE=2 FACE="Arial">Karl</FONT></SPAN>
</P>
<BR>
<BR>
<BR>
<BR>
</BODY>
</HTML>