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-29 15:39:09
Message-ID: 4C01351D.9060207@sensacd.com.mx (view raw or flat)
Thread:
Lists: pgsql-general

On 05/28/2010 04:58 PM, Adrian Klaver wrote:
> On Friday 28 May 2010 1:34:24 pm erobles wrote:
>    
>> On 05/28/2010 03:18 PM, alvherre wrote:
>>      
>>> Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010:
>>>        
>>>> 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.
>>>>          
>>> Of course it didn't work if you tried to run it in 7.2; you're supposed
>>> to run it in the 8.3 server, not the old one.  The point is to make 8.3
>>> sort-of compatible with the old behavior.
>>>        
>> did you see the script?
>>
>> didn't  it work because the  first command is a psql  pointing a pg
>> server 8.2
>> the second command is a psql pointing a pg server 8.3
>> then  the command  are executed   and  get the differences
>> after that  made the  properly casting fucntions
>>
>>
>> this result ok , because the postgres 8.x.x have the same database
>> catalog.... in this case have the table pg_cast
>> so the query works  OK.
>>
>>
>>
>> the problem in the postgres 7.2   doesn't exists  the table pg_cast so i
>> can't get the information need it to  get the differences
>>
>> so, i need  modify the first command  run it and get the  info in the
>> same format to get it.
>>      
> I believe you are looking at the wrong file; the shell script. Try instead the
> other link http://wiki.postgresql.org/wiki/Image:Pg83-implicit-casts.sql It
> contains the functions you need.
>
>    
thanks!




In response to

pgsql-general by date

Next:From: Jerry LeVanDate: 2010-05-29 17:18:58
Subject: Fedora 13 and yum.pgsqlrpms.org
Previous:From: Tom LaneDate: 2010-05-29 14:46:59
Subject: Re: Error of text2ltree

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