[postgis-users] missing proj4text in spatial_ref_sys causing dump restore problems.

[Ben Madin]

G'day all,

I'm having some problems with dumping / restoring a database, I think due to missing proj4text in the definitions. I'll preface this with a note that I don't want this particular projection, so I could just delete it, but the mechanism for the problem is intriguing me.

the problems are in the srid=2046 - 2055 range Hartebeesthoek94.

from sptatial_ref_sys.sql

---
--- EPSG 2046 : Hartebeesthoek94 / Lo15
---
INSERT INTO "spatial_ref_sys" ("srid","auth_name","auth_srid","srtext","proj4text") VALUES (2046,'EPSG',2046,'PROJCS["Hartebeesthoek94 / Lo15",GEOGCS["Hartebeesthoek94",DATUM["Hartebeesthoek94",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6148"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4148"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Transverse_Mercator_South_Orientated"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",15],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["EPSG","2046"],AXIS["Y",WEST],AXIS["X",SOUTH]]','');

When I dump, I get :

2046	EPSG	2046	PROJCS["Hartebeesthoek94 / Lo15",GEOGCS["Hartebeesthoek94",DATUM["Hartebeesthoek94",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6148"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4148"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Transverse_Mercator_South_Orientated"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",15],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["EPSG","2046"],AXIS["Y",WEST],AXIS["X",SOUTH]]

with no extra whitespace (ie tabs) at the end, so my attempt to load ends with 

_postgis.dump:15201: ERROR:  missing data for column "proj4text"
CONTEXT:  COPY spatial_ref_sys, line 476: "2046	EPSG	2046	PROJCS["Hartebeesthoek94 / Lo15",GEOGCS["Hartebeesthoek94",DATUM["Hartebeesthoek94",S..."

both the original database and the new one are in utf8, the file was dumped on my local machine and shared via subversion, but I'm still having the same problem on my local machine. 

I can get around it by deleting these before dumping, or maybe by using full inserts, but I'd rather not do that for size reasons - my questions are:

why has the space been lost, and
has this never happened to anyone else, and 
why does this group of projections not have proj4text?

cheers

Ben