srtext 2048 length limit

[Paul Ramsey]

> On May 21, 2025, at 2:08 AM, Denis Rykov <rykovd at gmail.com> wrote:
> 
> I noticed that the srtext column in the spatial_ref_sys table has a length limit of 2048 characters. This seems quite restrictive, especially considering the WKT standard does not prescribe a specific maximum length. In fact, it recommends a maximum of 4096 characters for CRS WKT strings. The current limit is therefore only half of what the standard suggests as a recommended maximum.
> 
> Could you please explain the rationale behind this strict limit, and could its extension be considered?

This is a direct copy from the OGC spec, I am pretty sure, and I don’t think there’s any reason we could not use the PgSQL ’text’ type instead.

That said, we haven’t had any issues with running out of space so far, 24 years in.

P.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250521/328caec2/attachment.htm>