Re: ignoring data type

Поиск
Список
Период
Сортировка
От Samuel Stearns
Тема Re: ignoring data type
Дата
Msg-id 68B59BEDCD36854AADBDF17E91B2937A0783A72A35@EXCHMAIL.staff.internode.com.au
обсуждение исходный текст
Ответ на ignoring data type  (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.



 

В списке pgsql-admin по дате отправления: