[fdo-users] FDOPostGIS 3.4L AutoCAD Map 3d 2010 Data Connection to features with numberstring as a fieldname does not work

Hermann Karl Karl.Hermann at dornbirn.at
Tue Aug 4 11:53:54 EDT 2009

Dear List,

CREATE TABLE "blocktest2" (gid serial PRIMARY KEY,
"blockname" varchar(255),
"layer" varchar(255),
"rotation" numeric,
"3" varchar(255),
"u" varchar(255));
SELECT AddGeometryColumn('','blocktest2','the_geom','-1','POINT',2);
INSERT INTO "blocktest2"
("blockname","layer","rotation","3","u",the_geom) VALUES
INSERT INTO "blocktest2"
("blockname","layer","rotation","3","u",the_geom) VALUES

trying to add this postgis featureset to the map causes
the error messages below

Storage of the objects in the Cache failed

The execution of the select command failed

the fdo driver tries do select with following syntax

select "public"."blocktest2".3 from "public"."blocktest2";

the error message from postgres is

ERROR: syntax error at or near ".3"
SQL state: 42601
Character: 29

select "public"."blocktest2"."3" from "public"."blocktest2";

would work in postgres


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20090804/6e90fff4/attachment-0001.html

More information about the fdo-users mailing list