From: Octavio <octaviomaiden@yahoo.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: ignoring data type
Date: Tue, 16 Nov 2010 09:15:17 -0800 (PST)
Message-ID: <768188.18183.qm@web38908.mail.mud.yahoo.com> (raw)
In-Reply-To: <AANLkTimt5d9qHct4LDEXb2PJvgS+X=HHjDJA+E9g0anu@mail.gmail.com>
Thanks Scott
In fact checking the application there are a lots of queries that doesn't make 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 <scott.marlowe@gmail.com> escribió:
De: Scott Marlowe <scott.marlowe@gmail.com>
Asunto: Re: [ADMIN] ignoring data type
A: "Octavio" <octaviomaiden@yahoo.com>
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 <octaviomaiden@yahoo.com> wrote:
>
> Hello
>
> I have migrate a application from a server with postgres 8.1 to another with 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 missing?
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. So, you might need to either change some column types,
or cast them explicitly to the type you want to be used for
comparison.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: octaviomaiden@yahoo.com, scott.marlowe@gmail.com
Subject: Re: ignoring data type
In-Reply-To: <768188.18183.qm@web38908.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox