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.