On Tue, Sep 28, 2010 at 12:37:46PM +0600, AI Rumman wrote:
> I migrated data from Postgresql 8.1 to Postgresql 8.4 using
> pg_dump. But now I found that, most of the queries in my
> applicaiton are being failed. Invesitigating the problem, I found
> that no function is available in the DB to CAST INT to TEXT etc.
This is due to sloppy coding in your code base, which was, unknown to
you, capable of producing "surprising," and by "surprising," I mean
"glaringly wrong" answers. You need to find the places where your
code base contains this slop and clean it up.
I can't really recommend that you put in workarounds, as they don't
actually fix the bugs you've found.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate