Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#3352 closed defect (fixed)

not all entries in spatial_ref_sys are marked as part of the extension

Reported by: pramsey Owned by: pramsey
Priority: medium Milestone: PostGIS 2.2.1
Component: postgis Version: 2.2.x
Keywords: Cc:


About 100 new spatial_ref_sys entries are un-marked as part of the extension, so they are being dumped by pg_dump.

Change History (4)

comment:1 Changed 5 years ago by pramsey

As of r14332 the results of the compute_srid_continuous_ranges function run on 2.2 are part of the extension.

comment:2 Changed 5 years ago by pramsey

Resolution: fixed
Status: newclosed

comment:3 Changed 5 years ago by pramsey

Forgot to patch the 2.2 branch as well as trunk, done in 2.2 now too at r14333

comment:4 Changed 5 years ago by pramsey

One more comment here: during extension upgrade two things don't happen:

  • the contents of spatial_ref_sys are not updated with the new contents
  • the definition of what parts of spatial_ref_sys are not to be dumped is not updated

As it happens, these two non-upgrades are perfectly complementary, so there's no need to change them, but it's worth noting that this is what happens.

Note: See TracTickets for help on using tickets.