[postgis-users] Importing shapefiles with srid != -1

[James Dominy]

Lee Hachadoorian wrote:
> Is there any chance spatial_ref_sys is missing srid 4326?

spatial_ref_sys has srid 4326. I was surprised that shp2pgsql didn't pick up the 
srid from the .prj file though. Setting it manually worked out fine. The 
constraint error was due to leaving out the quotes around the srid in the 
AddGeometry call.

Thanks
James