[postgis-users] populating a table

[Malm Paul]

Hi!

This has worked before, could anyone please tell me what's wrong?
I'm trying to create and populate a Table in my database with a script
generated with shp2pgsql.exe SQL:
BEGIN;
CREATE TABLE "public"."h1707640_cul_transl" (gid serial PRIMARY KEY,
"f_code" varchar(5),
"f_code_des" varchar(254),
"exs" int2,
"exs_descri" varchar(254),
"tile_id" int2,
"edg_id" int4,
"shape_leng" numeric);
SELECT
AddGeometryColumn('public','h1707640_cul_transl','the_geom','-1','MULTIL
INESTRING',2);

INSERT INTO "public"."h1707640_cul_transl"
("f_code","f_code_des","exs","exs_descri","tile_id","edg_id","shape_leng
",the_geom) VALUES
('AP030','Road','28','Operational','1','6','3.05816496139e004','01050000
000100000001020000000300000084F6FF3F5A8152C0580100E0D26144402C2000C05C81
52C02A2E00C0D361444007EDFF1F5F8152C055210060D2614440');
END;


I'm getting the following error message:
NOTICE:  CREATE TABLE will create implicit sequence
"h1707640_cul_transl_gid_seq" for serial column
"h1707640_cul_transl.gid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"h1707640_cul_transl_pkey" for table "h1707640_cul_transl"

ERROR: function addgeometrycolumn("unknown", "unknown", "unknown",
"unknown", "unknown", integer) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You may
need to add explicit type casts.
Character: 225


Paul Malm
Saab Systems, Naval Systems Division
Tel: +46 8 580 838 22
Mobile: +46 734 373 822


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070312/5f09108a/attachment.html>