PostgreSQL upgraded from 8.1 to 8.3

Publicado el viernes 17 octubre 2008, a 22:46 UTC

Hi,

Due to a user request to use tsearch2, we upgraded PostgreSQL from 8.1 to 8.3 without any other consideration ;) It should have taken a few minutes but of course it would have been too easy, so we fought against bugs and finally spent several hours on it.

There are many changes between these two versions, please read the PostgreSQL release notes ;)

Beside other things, the charset used internally is now based on the system locale, we had some legacy databases from PostreSQL 7.x without any charset set and legacy databases from 8.1 with wrong charset information (database set as LATIN1 with UTF8 characters inside), we converted roughly everything to UTF8. There might be charset glitch, please fix your databases ;-)

If anything else than charset issue is not working as it should, please contact us.

Admins'