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

1 message Options
Embed this post
Permalink
Hermann Karl

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

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)
FDOPostGIS 3.4L AutoCAD Map 3d 2010 Data Connection to features with numberstring as a fieldname does not work

Dear List,

BEGIN;
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 ('GN1','GN','0.000000000000000','789',NULL,'0101000000FDA08A2C9FB3E3C0B9770762A8FA0E41');

INSERT INTO "blocktest2" ("blockname","layer","rotation","3","u",the_geom) VALUES ('GN2','GN','0.000000000000000','2345','6','0101000000E54B15C275B3E3C053379F6D81F90E41');

END;

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


Karl




_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users