Hi Jose,
why haven't you post an example of the failing query, data and the exact
error message? The casting should work on 8.3 (and it works for me) so I
guess there are some invalid data, invalid SQL or something like that.
Anyway I doubt this is a performance issue - this falls into generic SQL
mailing list.
regards
Tomas
> ---------- Forwarded message ----------
> From: jose fuenmayor <jafn82@gmail.com>
> Date: Wed, Jan 7, 2009 at 2:56 PM
> Subject: Casting issue!!
> To: psql-admin@postgresql.org
>
>
> Hi all I am trying to migrate from postgresql 8.2.x to 8.3.x, i have an
> issue with casting values when i try to perform the auto cast , it does
> not
> work and I get an error, how can i perform auto casting on 8.3 without
> rewrite my source code, I am using pl/pgsql. I mean i dont want to write
> value::dataType. I dont want to use explicit type cast. Maybe change
> something in the config files? to make it work like 8.2 on tha regard(cast
> values).
> thanks a lot!!!
> Kind Regards;
> Jose Fuenmayor
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ç
>