Whats happening is that geotools doesnt know how to either encode
"bigint" or "numeric" datatypes. I dont know why udig is requesting
GML with ALL the columns in it just to get a count of features...
try this (this is gonna destroy your table, so make sure you have a
backup):
1. ALTER TABLE subway_stations DROP COLUMN objectid
2. stop geoserver and quit udig
3. restart geoserver and udig
4. try it again (it will either work or not work)
5. ALTER TABLE subway_stations DROP COLUMN id
6. stop geoserver and quit udig
7. restart geoserver and udig
8. try it again (it will either work or not work)
It should work after step 8, and it might work after step 4. Please
tell me which one works...
dave
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/
comment: this postgis table was created by the shp2pgsql utility. probably that utility shouldn't create column types that dont work in GML, right? or at least should have an option to munge with that priority.
editing the resultant pgsql to fix the column types and re-loading the table, the subway_stations table looks like this now, and it still doesn't work:
fundrace=# \d subway_stations
Table "public.subway_stations"
Column | Type | Modifiers
-----------+-------------------+------------------------------------------------------------------
gid | integer | not null default nextval('public.subway_stations_gid_seq'::text)
objectid | integer |
id | double precision |
name | character varying |
alt_name | character varying |
cross_st | character varying |
long_name | character varying |
label | character varying |
borough | character varying |
nghbhd | character varying |
routes | character varying |
transfers | character varying |
color | character varying |
express | character varying |
closed | character varying |
the_geom | geometry |
Indexes:
"subway_stations_pkey" primary key, btree (gid)
Check constraints:
"enforce_srid_the_geom" CHECK (srid(the_geom) = -1)
"enforce_dims_the_geom" CHECK (ndims(the_geom) = 2)
"enforce_geotype_the_geom" CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL)
thanks again,
mike
dblasby@anonymised.com wrote:
Whats happening is that geotools doesnt know how to either encode
"bigint" or "numeric" datatypes. I dont know why udig is requesting
GML with ALL the columns in it just to get a count of features...
try this (this is gonna destroy your table, so make sure you have a
backup):
1. ALTER TABLE subway_stations DROP COLUMN objectid
2. stop geoserver and quit udig
3. restart geoserver and udig
4. try it again (it will either work or not work)
5. ALTER TABLE subway_stations DROP COLUMN id
6. stop geoserver and quit udig
7. restart geoserver and udig
8. try it again (it will either work or not work)
It should work after step 8, and it might work after step 4. Please
tell me which one works...
dave
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/
--
Michael Frumin
R&D Technical Director
EYEBEAM
540 W 21st St
New York, NY 10011
+1 212.937.6580 x 241
mfrumin@anonymised.com
http://research.eyebeam.org