AddGeometryColumns has a problem with certain SRID's

[soi]

AddGeometryColumns() reports lots of given SRID's (all i tested it with except -1) as invalid but at the same time it is possible to change the SRID with UpdateGeometrySRID(). Corrensponding logs follow.

2012-02-20 14:52:27 CET LOG: statement: CREATE TABLE "shape_basin" (gid serial PRIMARY KEY,

"sampleid" varchar(50), "area" float8);

2012-02-20 14:52:46 CET LOG: statement: SELECT AddGeometryColumn(,'shape_basin','the_geom',4326,'MULTIPOLYGON',2); 2012-02-20 14:52:46 CET ERROR: AddGeometryColumns() - invalid SRID

However this is possible:

2012-02-20 14:55:21 CET LOG: statement: SELECT AddGeometryColumn(,'shape_basin','the_geom',-1,'MULTIPOLYGON',2); 2012-02-20 14:55:57 CET LOG: statement: SELECT UpdateGeometrySRID('shape_basin', 'the_geom', 4326);

[Mike Taves]

With your database, do you get any rows returned with this query:

SELECT * FROM spatial_ref_sys
WHERE srid=4326;

My guess is that you haven't populated spatial_ref_sys yet.

[soi]

Yes you were right. I fixed it by applying spatial_ref_sys.sql.