From: | erobles <erobles(at)sensacd(dot)com(dot)mx> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: there is a way to deactivate type validation on 8.3.1???? |
Date: | 2010-05-28 20:08:23 |
Message-ID: | 4C0022B7.4060603@sensacd.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Janning | 2010-05-28 20:09:22 | Re: Statement Pooling |
Previous Message | erobles | 2010-05-28 19:22:16 | Re: No lidbl.so in libpq.so (postgresql 8.4.4) |