<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><br id="lineBreakAtBeginningOfMessage"><div><br><blockquote type="cite"><div>On May 21, 2025, at 2:08 AM, Denis Rykov <rykovd@gmail.com> wrote:</div><br class="Apple-interchange-newline"><div><div dir="ltr">I noticed that the <code>srtext</code> column in the <code>spatial_ref_sys</code> 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.<br><br>Could you please explain the rationale behind this strict limit, and could its extension be considered?</div>
</div></blockquote><br></div><div>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.</div><div><br></div><div>That said, we haven’t had any issues with running out of space so far, 24 years in.</div><div><br></div><div>P.</div><br></body></html>