| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Octavio <octaviomaiden(at)yahoo(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: ignoring data type |
| Date: | 2010-11-16 06:22:41 |
| Message-ID: | AANLkTimt5d9qHct4LDEXb2PJvgS+X=HHjDJA+E9g0anu@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Nov 15, 2010 at 10:28 PM, Octavio <octaviomaiden(at)yahoo(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2010-11-16 08:31:19 | Re: Postgres error: could not open relation base/xxxxx/yyyyy |
| Previous Message | Samuel Stearns | 2010-11-16 05:41:41 | Re: ignoring data type |