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: 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 (view raw or flat)
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

In response to

Responses

pgsql-general by date

Next:From: JanningDate: 2010-05-28 20:09:22
Subject: Re: Statement Pooling
Previous:From: eroblesDate: 2010-05-28 19:22:16
Subject: Re: No lidbl.so in libpq.so (postgresql 8.4.4)

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