Re: ignoring data type

[Samuel Stearns <SStearns@xxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Octavio
Sent: Tuesday, 16 November 2010 3:58 PM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: 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.