Actually the shp2pgsql loader completely ignores the prj file and the pgsql2shp doesn't create a prj file. That's one of those nice to have features that should be on the to do list if it isn't. Its of very minor importance compared to other stuff though.
Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Dominy Sent: Monday, May 12, 2008 9:01 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Importing shapefiles with srid != -1 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
