Menu
▾
▴
#25 Upgrade fails on Postgres 8.1
I had some trouble upgrading from an ancient 0.5.?g version to the most recent version (0.5.8) on my Postgres 8.1 backed site. The upgrade failed on any UPDATE query where the table name was used in the SET or WHERE clauses. Removing the table name fixed the problem (see attached patch). For example, I had to use SET [::value] = ... instead of SET [mapMap::value] = ...
Thanks for all the work that's gone into this module!
-Steve (one of the original developers)
Patch fixes upgrade against postgres 8.1
That doesn't surprise me. The upgrade schema was not created correctly (using the Makefiles), so there probably isn't proper support for Postgres. I've fixed this in SVN (I think) but still haven't added the code to trigger it for upgrades, so it's not 100% yet. It should work for new installs, though (from the SVN code).