Re: [GENERAL] Implicit CAST is not working in Postgresql 8.4

2010-09-28 Thread David Fetter
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

Re: [GENERAL] Implicit CAST is not working in Postgresql 8.4

2010-09-27 Thread Pavel Stehule
Hello see http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html Regards Pavel Stehule 2010/9/28 AI Rumman : > 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.

Re: [GENERAL] Implicit CAST is not working in Postgresql 8.4

2010-09-27 Thread Thom Brown
On 28 September 2010 07:37, 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 e

[GENERAL] Implicit CAST is not working in Postgresql 8.4

2010-09-27 Thread AI Rumman
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. Most of the queries are failed because implicit ca