[postgis-users] ST_Transform error (proj4 string error)

[Cedric Duprez]

I'll try to give you a better idea of my configuration :
Server: Ubuntu 12.04 (server version), 64-bit
PostgreSQL: version 9.2.2, compiled in directory /opt/postgreSQL/9.2
Geos: version 3.3.5, installed like this: ./configure --prefix=/opt/postgreSQL/9.2 && make && make install
Proj4: version 4.8.0 with proj-datumgrid-1.5.zip unzipped in its /nad directory, compiled like this:./configure --prefix=/opt/postgreSQL/9.2 && make && make install
Postgis: version 2.0.2, ./configure --with-pgconfig=/opt/postgreSQL/9.2/bin/pg_config --with-geosconfig=/opt/postgreSQL/9.2/bin/geos-config && make && make install

I installed the postgis extensions in postgreSQL from pgAdmin.

I add my 2 custom SRID as this:

insert into spatial_ref_sys values (910001,'IGNF',310024140,'PROJCS["Lambert 93",GEOGCS["Réseau géodésique français 1993",DATUM["Réseau géodésique français 1993",SPHEROID["IAG GRS 1980",6378137.0000,298.2572221010000,AUTHORITY["IGNF","ELG037"]],TOWGS84[0.0000,0.0000,0.0000,0,0,0,0],AUTHORITY["IGNF","REG024"]],PRIMEM["Greenwich",0.000000000,AUTHORITY["IGNF","LGO01"]],UNIT["degree",0.01745329251994330],AXIS["Longitude",EAST],AXIS["Latitude",NORTH],AUTHORITY["IGNF","RGF93G"]],PROJECTION["Lambert_Conformal_Conic_2SP",AUTHORITY["IGNF","PRC0140"]],PARAMETER["semi_major",6378137.0000],PARAMETER["semi_minor",6356752.3141],PARAMETER["latitude_of_origin",46.500000000],PARAMETER["central_meridian",3.000000000],PARAMETER["standard_parallel_1",44.000000000],PARAMETER["standard_parallel_2",49.000000000],PARAMETER["false_easting",700000.000],PARAMETER["false_northing",6600000.000],UNIT["metre",1],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["IGNF","LAMB93"]]','+init=IGNF:LAMB93');
insert into spatial_ref_sys values (910002,'IGNF',320002120,'PROJCS["Lambert II étendu",GEOGCS["Nouvelle Triangulation Française Paris grades",DATUM["NTF",SPHEROID["Clarke 1880 IGN",6378249.2000,293.4660210000000,AUTHORITY["IGNF","ELG010"]],TOWGS84[-168.0000,-60.0000,320.0000,0,0,0,0],AUTHORITY["IGNF","REG002"]],PRIMEM["Paris",2.337229167,AUTHORITY["IGNF","LGO02"]],UNIT["grad",0.01570796326794897],AXIS["Longitude",EAST],AXIS["Latitude",NORTH],AUTHORITY["IGNF","NTFP"]],PROJECTION["Lambert_Conformal_Conic_1SP",AUTHORITY["IGNF","PRC0120"]],PARAMETER["semi_major",6378249.2000],PARAMETER["semi_minor",6356515.0000],PARAMETER["latitude_of_origin",46.800000000],PARAMETER["central_meridian",0.000000000],PARAMETER["scale_factor",0.99987742],PARAMETER["false_easting",600000.000],PARAMETER["false_northing",2200000.000],UNIT["metre",1],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["IGNF","LAMBE"]]','+init=IGNF:LAMBE');

When I try the following query:
select *, ST_Transform(ST_SetSRID(ST_MakePoint(xl, yl), 910002), 910001) AS geom 
from (values (556866, 1902345) , (689174, 2448195) , (729095, 2528577) , (335755, 2059702) , (623207, 2210468) , (850337, 1871486) , (915275, 1889534) , (639551, 1778327) , (584365, 2273523) , (649599, 2228833)) as t(xl, yl);

I get the following error: ERROR: AddToPROJ4SRSCache: could not parse proj4 string '+init=IGNF:LAMBE' no system list, errno: 2

What is wrong in my configuration that could explain this error?
Is my ntf_rgf93.gsb file at the wrong place?

Thanks in advance for your help.

Cedric