Opened 9 years ago

Closed 6 years ago

#2029 closed defect (invalid)

PostgreSQL geometric to PostGIS type casts missing in extension upgrade script

Reported by: robe Owned by: pramsey
Priority: high Milestone: PostGIS 2.2.0
Component: build/upgrade/install Version: main
Keywords: Cc:

Description

To my horror, when upgrading from unpackaged, I discovered my free wheeling PostGIS database was missing the new path, lsegment, point etc. casts introduced in:

r10336

and therefore could not be wrapped up in neat little extension package.

Have issues with raster too still with unionarg order of operation, seems aggregate is being created before my typedef can kick in or dering but that's in another ticket already.

Change History (6)

comment:1 Changed 9 years ago by robe

Owner: changed from strk to robe
Summary: PostgreSQL geometric to PostGIS type casts missing in upgrade scriptPostgreSQL geometric to PostGIS type casts missing in extension upgrade script

I was wrong this is only an extension issue because I'm explicitly removing create type cast etc. statements on the postgis side. Forget why I'm doing that. The 20_21 script does have the casts as it should and the 21_minor I don't think does which is also correct.

comment:2 Changed 8 years ago by robe

Milestone: PostGIS 2.1.0PostGIS 2.2.0

comment:3 Changed 7 years ago by robe

This might have been fixed with strk's recent changes to upgrade generator script. I need to recheck this.

comment:4 Changed 6 years ago by robe

Priority: blockermedium

comment:5 Changed 6 years ago by robe

Owner: changed from robe to pramsey
Priority: mediumhigh

comment:6 Changed 6 years ago by pramsey

Resolution: invalid
Status: newclosed

I'm seeing these casts in upgrade scripts, so I think this ticket is now invalid.

Note: See TracTickets for help on using tickets.