pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedignoring data type
4+ messages / 3 participants
[nested] [flat]
* ignoring data type
@ 2010-11-16 05:28 Octavio <octaviomaiden@yahoo.com>
0 siblings, 2 replies; 4+ messages in thread
From: Octavio @ 2010-11-16 05:28 UTC (permalink / raw)
To: pgsql-admin
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?
Thanks
Octavio
the error in spanish
2010-11-15 19:03:21 PET UBICACIÃN: op_error, parse_oper.c:896
2010-11-15 19:03:21 PET SENTENCIA: update clamcartga set codusuario=$1,fechapro=$2,horapro=$3,fechaenv=$4,flenvmail=$5 wh
ere corrabon=$6 and tipoafil=$7 and numcaso=$8 and corpacien=$9 and tipcarta=$10 and corrcart=$11
2010-11-15 19:06:16 PET ERROR: 42883: el operador no existe: character = integer en carácter 383
2010-11-15 19:06:16 PET HINT: Ningún operador coincide con el nombre y el tipo de los argumentos. Puede desear agregar convesiones explÃcitas de tipos.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ignoring data type
@ 2010-11-16 05:41 Samuel Stearns <SStearns@internode.com.au>
parent: Octavio <octaviomaiden@yahoo.com>
1 sibling, 0 replies; 4+ messages in thread
From: Samuel Stearns @ 2010-11-16 05:41 UTC (permalink / raw)
To: Octavio <octaviomaiden@yahoo.com>; pgsql-admin
What does a \d on the table 'clamcartga' in both environments say? Can you spot any differences between the 8.1 and 8.3 environments?
Sam
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Octavio
Sent: Tuesday, 16 November 2010 3:58 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] ignoring data type
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?
Thanks
Octavio
the error in spanish
2010-11-15 19:03:21 PET UBICACIÃN: op_error, parse_oper.c:896
2010-11-15 19:03:21 PET SENTENCIA: update clamcartga set codusuario=$1,fechapro=$2,horapro=$3,fechaenv=$4,flenvmail=$5 wh
ere corrabon=$6 and tipoafil=$7 and numcaso=$8 and corpacien=$9 and tipcarta=$10 and corrcart=$11
2010-11-15 19:06:16 PET ERROR: 42883: el operador no existe: character = integer en carácter 383
2010-11-15 19:06:16 PET HINT: Ningún operador coincide con el nombre y el tipo de los argumentos. Puede desear agregar convesiones explÃcitas de tipos.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ignoring data type
@ 2010-11-16 06:22 Scott Marlowe <scott.marlowe@gmail.com>
parent: Octavio <octaviomaiden@yahoo.com>
1 sibling, 1 reply; 4+ messages in thread
From: Scott Marlowe @ 2010-11-16 06:22 UTC (permalink / raw)
To: Octavio <octaviomaiden@yahoo.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ignoring data type
@ 2010-11-16 17:15 Octavio <octaviomaiden@yahoo.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Octavio @ 2010-11-16 17:15 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-11-16 17:15 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-16 05:28 ignoring data type Octavio <octaviomaiden@yahoo.com>
2010-11-16 05:41 ` Samuel Stearns <SStearns@internode.com.au>
2010-11-16 06:22 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-11-16 17:15 ` Octavio <octaviomaiden@yahoo.com>
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