-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Medi Montaseri wrote: > Hi, > > I have finally convinced my manager to "consider" the idea of migrating from > 7.2 to 8.2. Obviously he needs an ROI (Return Of Investment) analysis (in a > technical sense). > > So, I am wondering if anyone has worked on a similar project where you had > to go thru the release notes and bug fixes to compile such a motivational > speech and willing to share. > > Otherwise, as many links you can provide would be nice. Wow... Does your manager still run Windows 98? Not to be sarcastic but that is essentially what the argument boils down to. 1. 7.2 is *not* supported 2. 7.2 will not receive any backpatches * There are data loss and security bugs that have not been back patched 3. If you post here with a question about 7.2, the first thing you will get back is, "upgrade". 4. 8.2 is much faster (not like 10%, like 100%) Now what problems are you going to run into? Several datatypes in 7.2 are allowed to be '', in 8.x they are not. Specifically number based types. You may have to turn "on" add_missing_from_clause Sincerely, Joshua D. Drake > > Cheers > Medi > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGyyABATb/zqfZUUQRAk0SAJ9kQ2LvZ9MoCVwZX7gHgSB8NNgxygCfYp5a bxD4582Zw+WM2XCEy38idCM= =dP3b -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend