Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 043E41337B5B for ; Tue, 16 Nov 2010 13:15:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 11208-06 for ; Tue, 16 Nov 2010 17:15:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web38908.mail.mud.yahoo.com (web38908.mail.mud.yahoo.com [209.191.125.114]) by mail.postgresql.org (Postfix) with SMTP id A25F31337B4F for ; Tue, 16 Nov 2010 13:15:19 -0400 (AST) Received: (qmail 19077 invoked by uid 60001); 16 Nov 2010 17:15:17 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1289927717; bh=K6ur3dvu4Yact4WbK1ibRfYQQDBaW7A2uTlhDmYENpI=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=yBMNVwsyF1qbbsQOwrcOHseICXUjMK5rB86dblj8dtsGtDjdg3uQrNgg/rIefcJ8y/BgW6hGnjnB1zwDea7C4m+xln/yRGbu3kGhkzVbfgJmUuNo+ml6TY1XHeOFicInRgUbbTe+PEjT3/sjLA3g+C0IAgRKhQlbUSCgXknEr+I= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=oQaC/C542X7NYCkn7RmO4mWsV52K5WAH1Jyz3QZbokxCEGvACmZ3ycW2XIjUIa1/uRiL5rI6yHL6tfOgfX0s07G7o/3CE8t7341qYTFAIJFlCpTTw6eZDB/1z+R8ahvxt18q+4fDl2EvOoU88R80AEshNPMlUReTo9rPVDW2vvY=; Message-ID: <768188.18183.qm@web38908.mail.mud.yahoo.com> X-YMail-OSG: 1kYhU4QVM1k0IZC04MEBqOt5vUBSSltWnG5pC0ai4K7v65z V7x.lGfDUr9SSx98_YmPWkW4KJWsDH3so7CPP0N7NBrwefc.jfYdqE2lmnX_ muP0zpEJcpGbHePAKKOQl_nRUOcb.khsF8wbCf4tlSdp.0WHYYDeKSX.2eMa AodB42yduSEOz7z4OSKKVp_VCFuO9jzR301OKp6w9TlCqq9sv_IajppgylBJ zhUID7w.KcJNxW9llslGasnJr8sZLefyLwDwFeRA6jbKUqot6LsUF_XxC3Vd v9O2H72_lKLbNQwKnr_JKdJ84s9NrKkzdx_GTRoTBvOPLr6kFyekXL7p.wdX PJgQWRBYeADlurcxWqbhm0rBwy2Azp5CpT2wLQKqze5VcKdZvlKyXumzGHv7 riF8Pv5I- Received: from [209.191.68.163] by web38908.mail.mud.yahoo.com via HTTP; Tue, 16 Nov 2010 09:15:17 PST X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.107.285259 Date: Tue, 16 Nov 2010 09:15:17 -0800 (PST) From: Octavio Subject: Re: ignoring data type To: Scott Marlowe Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1025881682-1289927717=:18183" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.908 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/136 X-Sequence-Number: 36102 --0-1025881682-1289927717=:18183 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Thanks Scott In fact checking the application there are a lots of queries that doesn't m= ake the conversion, in order to temporally skip this issue,I like to try to= import those conversions from the 8.1 version to the actual postgres, how = can I do that? Octavio --- El mar, 11/16/10, Scott Marlowe escribi=F3: De: Scott Marlowe Asunto: Re: [ADMIN] ignoring data type A: "Octavio" Cc: pgsql-admin@postgresql.org Fecha: martes, 16 de noviembre de 2010, 01:22 am On Mon, Nov 15, 2010 at 10:28 PM, Octavio wrote: > > Hello > > I have migrate a application from a server with postgres 8.1 to another w= ith 8.3 > in the new server there are some page that doesn't work because seems to = want to compare different data type > > does anyone know if it is a version issue or there is something Im missin= g? Starting in 8.3 many automatic conversions from one type to another were removed because it wasn't always obvious if this was the right thing to do.=A0 So, you might need to either change some column types, or cast them explicitly to the type you want to be used for comparison. =0A=0A=0A --0-1025881682-1289927717=:18183 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Thanks Scott

In fact checking the appl= ication there are a lots of queries that doesn't make the conversion, in or= der to temporally skip this issue,I like to try to import those conversions= from the 8.1 version to the actual postgres, how can I do that?

Oct= avio

--- El mar, 11/16/10, Scott Marlowe <scott.marlowe@gma= il.com> escribi=F3:

De: Scott Ma= rlowe <scott.marlowe@gmail.com>
Asunto: Re: [ADMIN] ignoring data = type
A: "Octavio" <octaviomaiden@yahoo.com>
Cc: pgsql-admin@pos= tgresql.org
Fecha: martes, 16 de noviembre de 2010, 01:22 am

On Mon, Nov 15, 2010 at 10:28 PM, Octavio <octaviomaiden@yahoo.com<= /a>> wrote:
>
> Hello
>
> I have migrate a appli= cation from a server with postgres 8.1 to another with 8.3
> in the n= ew server there are some page that doesn't work because seems to want to co= mpare different data type
>
> does anyone know if it is a versi= on issue or there is something Im missing?

Starting in 8.3 many auto= matic conversions from one type to another
were removed because it wasn'= t always obvious if this was the right
thing to do.  So, you might = need to either change some column types,
or cast them explicitly to the = type you want to be used for
comparison.

=0A=0A=0A=0A=0A   --0-1025881682-1289927717=:18183--