On 8 November 2010 10:08, AI Rumman <rumman...@gmail.com> wrote: > I am going to migrate my produciton DB from postgresql 8.1 to 9.0.1. > Anyone please tell me what the important things I have to look for this > migration. > Thanking you all. >
Implicit casting might bite you since that was removed in 8.3. Take a careful look at the migration notes for each release inbetween to see how they affect you: http://www.postgresql.org/docs/9.0/static/release-8-2.html#AEN106653 http://www.postgresql.org/docs/9.0/static/release-8-3.html#AEN104194 http://www.postgresql.org/docs/9.0/static/release-8-4.html#AEN101283 http://www.postgresql.org/docs/9.0/static/release-9-0.html#AEN98988 -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935