Skip site navigation (1) Skip section navigation (2)

Re: there is a way to deactivate type validation on 8.3.1????

From: erobles <erobles(at)sensacd(dot)com(dot)mx>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: there is a way to deactivate type validation on 8.3.1????
Date: 2010-05-28 19:04:45
Message-ID: 4C0013CD.20002@sensacd.com.mx (view raw or flat)
Thread:
Lists: pgsql-general

On 05/28/2010 01:51 PM, Adrian Klaver wrote:
> On 05/28/2010 11:45 AM, erobles wrote:
>>
>>
>> On 05/28/2010 01:26 PM, Adrian Klaver wrote:
>>> On 05/28/2010 11:20 AM, erobles wrote:
>>>> hi!
>>>> only for ask, there is a way to deactivate type validation, so i 
>>>> can do
>>>>
>>>> select rtrim(number_field) from table ; with no error and the message:
>>>> "You might need to explicit type casts"
>>>>
>>>> this is postgres 8.3.1.
>>>>
>>>
>>> What are you trying to do? I am trying to think what rtrim does on a
>>> number.
>>>
>>
>>
>> you are right, i'm trying to make a rtrim to a number.
>> the reason of my question is we have a lot of apps with similar querys ,
>> when we have postgres7.2 this kind of querys just simply execute very
>> well, so.. when change to postgres 8.3 this querys fail beacuse they
>> needit an explicit cast.
>>
>> one solution is change the querys of apps and recompile, but time is
>> short and the deadline is near.
>>
>> other solution is create a function to each explicit cast, but we dont
>> have the time to research if there are more mismatch querys.
>>
>> so the easy way is deactivate the validation type ...
>>
>>
>>
>>
>>
>> so another
>>
> For short term solution see here:
> http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html 
>
>
>

thanks, downloading and testing.....

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2010-05-28 19:16:36
Subject: Re: No lidbl.so in libpq.so (postgresql 8.4.4)
Previous:From: Adrian KlaverDate: 2010-05-28 18:51:04
Subject: Re: there is a way to deactivate type validation on 8.3.1????

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group