[postgis-devel] Turning spatial_ref_sys into a view to separate system vs. user entries

[Even Rouault]

>>> What happens if a user tries to delete from spatial_ref_sys an entry that
>>> comes from spatial_ref_sys_postgis ?
>>>
>>> I'm asking since GDAL autotest suite
>>> basically does "DELETE FROM spatial_ref_sys" + "INSERT INTO spatial_ref_sys
>>> blabla" for one of its PostGIS tests (I guess we could avoid such radical
>>> wiping out)
>> At the moment it does something like this:
>>
>>      ERROR:  System SRID (4326) cannot be deleted
> FYI: I've updated the code to work fine for your GDAL test case.
> (DELETE would ignore the request, with a NOTICE, and INSERT will
> create the overrides)
Well, if the DELETE doesn't delete, then the test is broken anyway, 
since it relies on DELETE FROM spatial_ref_sys resulting in an empty 
view/table. But I'd be fine adapting the test to use less radical ways 
if your proposal is merged.

Even

-- 
http://www.spatialys.com
My software is free, but my time generally not.