On Tue, Jul 17, 2012 at 11:34:46AM +0200, DUPREZ Cédric wrote: > SELECT AddGeometryColumn('public', 'pts', 'geom', 320002120, 'POINT', 2, > false); > > This gives me the following error message: "ERROR: AddGeometryColumn() - SRID > must be <= 998999 > > How can I use the correct 320002120 SRID specified by French IGN?
Is 320002120 in your spatial_ref_sys already ? You'll need to assign it a different SRID, the spatial_ref_sys has provision for "auth_srid" so you can put 320002120 in there and use something valid for PostGIS' "srid" field. Unfortunately we never got around writing a page about SRID ranges in PostGIS manual (contributions welcome!) but the idea is that you put your "custom" entries somewhere from 910000 and below 999000. --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.1 | / 2.1 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users