Στις Monday 08 September 2008 16:14:29 ο/η Devrim GÜNDÜZ έγραψε: > On Mon, 2008-09-08 at 11:35 +0800, Jumping wrote: > > I plan to update my database from 8.1.9 to 8.3.3. > > Is there any tricks or tips ? > > I would first update to 8.1.13, then go on. Hehe i upgraded from 7.4 to 8.3.3 and it was a big pain, but since i survived i'd say 8.1.9->8.3.3 is at least safe! It all depends on the quality (standard-wise) of the original SQL code however. > > Anysay, Read the release notes, and check for any possible > incompatibility issues. > > http://www.postgresql.org/docs/current/static/release-8-3.html > http://www.postgresql.org/docs/current/static/release-8-2.html > > I believe you should first check the casting changes in 8.3 . > > Regards, -- Achilleas Mantzios