ignoring data type

From: Octavio <octaviomaiden(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: ignoring data type
Date: 2010-11-16 05:28:04
Message-ID: 924615.2140.qm@web38904.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Samuel Stearns 2010-11-16 05:41:41 Re: ignoring data type
Previous Message Olli Aro 2010-11-15 23:22:50 could not map view of backend variables: error code 6