[PROJ] WKT2 in PostGIS

[Greg Troxel]

Javier Jimenez Shaw via PROJ <proj at lists.osgeo.org> writes:

> In the new PROJ release 9.9.0 that will be released soon, the latest
> version of EPSG is included.
> As I already mentioned, all European realizations are included in the WKT2
> of any CRS using the ETRS89 datum ensemble.
> This is an example of EPSG:25830, with 4264 chars.
> https://epsg.org/crs/wkt/id/25830
> If you format it a bit nicely it goes up to 4874. And this is just an
> example.
>
> I realized today that in PostGIS the table containing the CRS has fields
> limited to 2048 chars, in particular "srtext".
> https://postgis.net/docs/using_postgis_dbmanagement.html#spatial_ref_sys_table
>
> CREATE TABLE spatial_ref_sys (
>   srid       INTEGER NOT NULL PRIMARY KEY,
>   auth_name  VARCHAR(256),
>   auth_srid  INTEGER,
>   srtext     VARCHAR(2048),
>   proj4text  VARCHAR(2048)
> )

I have locally installed 9.9.0RC1 (and proj-data 1.25RC1, surely
unrelated), and built postgis.

Looking at spatial_ref_sys.sql, I see

--                                                                                                                                                                                                                                             
-- EPSG 25830 : ETRS89 / UTM zone 30N                                                                                                                                                                                                          
--                                                                                                                                                                                                                                             
(25830, 'EPSG', 25830, 'PROJCS["ETRS89 / UTM zone 30N",GEOGCS["ETRS89",DATUM["European_Terrestrial_Reference_System_1989",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6258"]]\
,PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4258"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",-3],PARA\
METER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","25830"]]', '+proj=utm +zone=30 +ellps=GRS8\
0 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs '),

which appears not to include the ensemble members.  I don't see a
postgis NEWS about a new EPSG version since 2.5.0, but obviously that
isn't how it is.