> > But if you added it to proj.db too with just the new srid you added in > spatial_ref_sys wouldn't it read from proj.db? > > Yeah, but, why? I don’t tend to think of proj.db as something normal humans > mess with, and definitely since it’s bundled with the proj software packages > there’s a likelihood of it getting overwritten on upgrade, which makes it a > poor > place for local customizations. >
I have lofty dreams of getting rid of spatial_ref_sys and making it a view against proj.db or something else. This eye-sore of us treating it like it's a non-volatile thing and PostgreSQL deciding to not load it in time in pg_upgrade wants me to not have it in the db at all. Not to mention the annoyance of keeping track of what we shipped and what we didn't. But yes it's perhaps an ill-conceived dream that lets out more worms than it traps.
