Opened 16 years ago
Last modified 15 years ago
#202 closed defect
upgrade issues — at Initial Version
| Reported by: | robe | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 1.4.1 |
| Component: | postgis | Version: | master |
| Keywords: | Cc: |
Description
I seem to have an issue after upgrade from 1.3.6 to 1.4.0 beta using the upgrade script. I'm investigating to see if its something funky with my database. Upgrade says it was okay, but:
When I try to build a gist index on one of my tables, I get this error ERROR: data type geometry has no default operator class for access method "gist" HINT: You must specify an operator class for the index or define a default operator class for the data type.
As expected — if I try to upgrade a 1.3.6 that uses views with aggregates it fails.
DETAIL: view vwtest depends on function collect(geometry) HINT: Use DROP … CASCADE to drop the dependent objects too.
Error
ERROR: cannot drop function collect(geometry) because other objects depend on it SQL state: 2BP01 Detail: view vwtest depends on function collect(geometry) Hint: Use DROP … CASCADE to drop the dependent objects too.
We should probably put a note somewhere in the upgrade instructions to have people drop such views and rebuild them after upgrade. Minor I know and who knows maybe I'm the only one who does crazy things like this.
The other issue — If I try to upgrade 1.4.0SVN to 1.4 beta — doesn't work — again not a biggie since I presume no one will be doing this. Just thought I would mention it. Gives:
ERROR: type "box3d_extent" already exists
Error
ERROR: type "box3d_extent" already exists SQL state: 42710
