| 1 | | 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: |
| 2 | | |
| 3 | | When I try to build a gist index on one of my tables, I get this error |
| 4 | | ERROR: data type geometry has no default operator class for access method "gist" |
| 5 | | HINT: You must specify an operator class for the index or define a default operator class for the data type. |
| 6 | | |
| 7 | | As expected -- if I try to upgrade a 1.3.6 that uses views with aggregates it fails. |
| 8 | | |
| 9 | | DETAIL: view vwtest depends on function collect(geometry) |
| 10 | | HINT: Use DROP ... CASCADE to drop the dependent objects too. |
| 11 | | |
| 12 | | ********** Error ********** |
| 13 | | |
| 14 | | ERROR: cannot drop function collect(geometry) because other objects depend on it |
| 15 | | SQL state: 2BP01 |
| 16 | | Detail: view vwtest depends on function collect(geometry) |
| 17 | | Hint: Use DROP ... CASCADE to drop the dependent objects too. |
| 18 | | |
| 19 | | 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. |
| 20 | | |
| 21 | | 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: |
| | 1 | 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: |
