Opened 14 years ago

Closed 14 years ago

#305 closed defect (invalid)

Upgrade scripts -- should have create or replace for all functions

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 1.5.0
Component: postgis Version: master
Keywords: Cc:

Description

I'm still testing, but I see you are not including all the functions in your upgrade scripts. You really should have a create or replace for all the functions regardless of which upgrade script — (we have a lot of installs out there you will find are not pure 1.5/1.4 or whatever … or whatever)

— I just tried upgrading one of my older postgis 1.5 installs (using minor upgrade) and if it were not for my wonderful postgis_comments.sql, I would not have realized a whole bunch of functions are missing.

e.g. function st_geographyfromtext(text) does not exist

— I still have yet to try on older 1.3, 1.4 — but just wanted to say we should always do a create or replace on all the functions.

Change History (1)

comment:1 by robe, 14 years ago

Resolution: invalid
Status: newclosed

Never mind — that's not the problem. Its because its erroring out.

Note: See TracTickets for help on using tickets.