"Mavinakuli, Prasanna (STSD)" <prasanna.b-m@xxxxxx> writes: > Thanks Alvaro for your time and suggestions.Yes we do understand that we > are expected to use the higher versions.But as Bruce pointed out > already,the same is NOT recommended when there is NO imperative > reason. Say again? Bruce's point was the opposite: not upgrading is generally more risky than upgrading. It's certainly true that we have sometimes introduced new bugs into minor version updates, but the odds of being bitten by one of those are considerably lower than the odds of being bitten by one of the ones we did fix. This is particularly true when you are talking about a release as ancient as 7.4.2 is. Read the release notes sometime: http://developer.postgresql.org/pgdocs/postgres/release.html and ask yourself if you really want to continue risking exposure to all the known, fixed bugs in the 7.4 series. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
