Opened 12 years ago

Closed 12 years ago

#1495 closed defect (wontfix)

PostGIS micro upgrade script doesn't update spatial_ref_sys

Reported by: robe Owned by: strk
Priority: medium Milestone: PostGIS 2.0.0
Component: build Version: master
Keywords: Cc:


During minor/micro upgrades our scripts do not update spatial_ref_sys. We probably should roll in fixed / added entries or reload just those that are in our list

with a

delete from spatial_ref_sys where srid IN(SELECT srid FROM postgis_spatial_ref_sys_official)

INSERT INTO spatial_ref_sys(...) SELECT ** FROM our new_list;

Change History (2)

comment:1 by robe, 12 years ago

Component: postgisbuild/upgrade/install
Owner: changed from pramsey to strk

comment:2 by pramsey, 12 years ago

Resolution: wontfix
Status: newclosed

I don't even want to keep this ticket around. We keep no records of what has changed in spatial_ref_sys, and we have so many bigger fishes to fry, and self-fixing on the part of end-users is so very easy if they happen to hit the very rare cases where a spatial_ref_sys problem occurs.

Note: See TracTickets for help on using tickets.