Opened 11 years ago

Closed 11 years ago

#1365 closed defect (fixed)

postgis_upgrade_20_minor.sql is broken

Reported by: robe Owned by: strk
Priority: critical Milestone: PostGIS 2.0.0
Component: postgis Version: master
Keywords: Cc:


Did someone change the perl script to upgrade minor. It's outputing spatial_ref_sys table (well trying to create it), thus it odesn't work. This might be the issue Aren Cambre was running into.

Can we please get rid of that. We didn't change the structure of spatial_ref_sys.

Change History (4)

comment:1 by strk, 11 years ago

Owner: changed from pramsey to strk
Status: newassigned

The structure changed adding:

  check (srid > 0 and srid < 999000)

The check would be safer to add after making sure nothing breaks it. Speaking of which, the new_postgis_upgrade script defines the table using the new definition and would thus fail loading data with SRID values ≥ 999000

comment:2 by strk, 11 years ago

The script seems to be fooled by definition of _ST_DumpPoints

comment:3 by strk, 11 years ago

alrigt,the script detects end of a function looking for a pattern: *LANGUGAGE

so fails for all functions where LANGUAGE is not on a line of itself. Pretty lame. It's full of missing upgrades…

comment:4 by strk, 11 years ago

Resolution: fixed
Status: assignedclosed

This is now fixed as r8379

Note: See TracTickets for help on using tickets.