From: | erobles <erobles(at)sensacd(dot)com(dot)mx> |
---|---|
To: | alvherre <alvherre(at)commandprompt(dot)com> |
Cc: | pgsql-general <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:34:24 |
Message-ID: | 4C0028D0.6020403@sensacd.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2010-05-28 20:44:47 | Re: List traffic |
Previous Message | alvherre | 2010-05-28 20:18:10 | Re: there is a way to deactivate type validation on 8.3.1???? |