David Robison wrote:
> I have created a Postgis table and am trying to load it into geoserver
> and I am getting the following error:
> ...
> The version of geoserver that I am using is using gt2 version
> 2.2.3-SNAPSHOT. Any idea what the problem might be? The code I used to
> create the table is:
>
> SELECT DropGeometryColumn('','inrix_tmc_codes','the_geom');
> DROP TABLE "inrix_tmc_codes";
> BEGIN;
> CREATE TABLE "inrix_tmc_codes" (gid serial PRIMARY KEY,
> "market_code" int4,
> "region" int4,
> "tmc_code" int4,
> "direction" char(1),
> "speed" int4,
> "color" int4,
> "route" varchar(254),
> "start_mm" numeric,
> "end_mm" numeric,
> the_geom geometry
> )
> WITHOUT OIDS;
> SELECT
> AddGeometryColumn('','inrixtmccodes','the_geom','-1','MULTILINESTRING',2);
> CREATE INDEX "inrix_tmc_codes_the_geom_gist" ON "inrix_tmc_codes" using
> gist ("the_geom" gist_geometry_ops);
>
> Any help would be appreciated. Thanks, David
Try removing the_geom from your create table statement
(AddGeometryColumn does this for you), and use this:
AddGeometryColumn('public','inrix_tmc_codes','the_geom','-1','MULTILINESTRING',2);
The prior statement tried to add a column to a non-existent table in the
schema "", with name "inrixtmccodes".
You'll also be happier if you specify the CRS of your data when you are
importing it; -1 will just cause you trouble later.
Cheers,
Cory.
----
Cory Horner
Refractions Research Inc.
http://www.refractions.net
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geotools-gt2-users mailing list
Geotools-gt2-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
