On 05/28/2010 02:04 PM, erobles wrote:
>
>
> 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.....
>
it did'nt work :-( , because the script is for pg 8.2 and i have pg
7.2 and the table pg_cast doesn't exist. whatever is a good idea but i
need to know the table or tables on postgres 7.2. such as pg_cast
on postgres 8.3, to modify the script.
How can i see the 'private' tables of postgres 7.2, i tried with \d on
template1 , if a made a select on pg_types i have a result, but i don't
know which is the name of the others tables such a