srtext 2048 length limit
Paul Ramsey
pramsey at cleverelephant.ca
Wed May 21 07:59:15 PDT 2025
> On May 21, 2025, at 7:43 AM, Regina Obe <lr at pcorp.us> wrote:
>
> The general advice is if you want to make changes, you should make it in your proj.db database since that is the first source of truth for PostGIS these days.
>
Er, not really. If you want to change an INSTALLED srs, then you kind of have to do it in proj.db, since that’s the first place we check when dereferencing an SRID number. If you want to ADD a new srs, you can add a line to spatial_ref_sys. Frankly, even if you wanted to change an existing srs, the smart thing to do would be to add a new line and a new srid number to spatial_ref_sys, because there’s nothing stopping proj.db from being over-written by software upgrades etc.
P
More information about the postgis-users
mailing list