From: | Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | ODBC Driver 9->11, troubles with dates/NULL... |
Date: | 2019-07-22 10:19:53 |
Message-ID: | 20190722101953.GF2802@sv.lnf.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
After long time, i've decided to upgrade ODBC driver from version 09.03.0100
to version 11.01.0000. A big jump, indeed.
I'm using an old application written in Centura, that with 09.03.0100
works as expected.
But with '11.01.0000' no. Throw the error:
2019-07-22 10:04:28 CEST [19212-1] barbaradg(at)regproto ERRORE: sintassi di input non valida per il tipo date: "" al carattere 524
2019-07-22 10:04:28 CEST [19212-2] barbaradg(at)regproto ISTRUZIONE: INSERT INTO PROTOCOLLI ( NUM_ORDINE, ANNO_REGIST, DATA_REGIST, SEDE, PADIGLIONE, DATA_ARRIVO, COD_PROV, PROVENIENZA, DATA_ATTO_RIC, NUM_ATTO_RIC, ESTR_CDESC_AR, ESTR_ATTO_RIC, NUM_ALLEGATI_AR, DATA_SPEDIZIONE, COD_IND, INDIRIZZO, ESTR_CDESC_AS, ESTR_ATTO_SPED, NUM_ALLEGATI_AS, NUM_RIF_PROT_AR, NUM_RIF_PROT_AS, CLASS_ARCH_AR, CLASS_ARCH_AS, SPESE_POSTALI_AR, SPESE_POSTALI_AS, COD_SETTORE_AR, COD_SETTORE_AS, COD_OPERATORE_AR, COD_OPERATORE_AS ) VALUES ( E'2163'::float8 , E'2019'::float8 , E'' , NULL , NULL , NULL , E'' , E'' , NULL , E'' , E'' , E'' , E'' , E'' , E'' , E'sometext' , E'' , E'sometext' , E'' , E'' , E'' , E'' , E'' , NULL , NULL , E'sometext' , E'' , E'sometext' , E'' )
error are relative to the first date field, 'DATA_REGIST', where the
input is:
E''
while the table expect a non-NULL:
Tabella "public.protocolli"
Colonna | Tipo | Modificatori
------------------+------------------------+--------------
num_ordine | integer | non null
anno_regist | integer | non null
data_regist | date | non null
sede | integer |
padiglione | integer |
data_arrivo | date |
cod_prov | character varying(5) |
provenienza | character varying(250) |
data_atto_ric | date |
num_atto_ric | character varying(20) |
estr_cdesc_ar | character varying(5) |
estr_atto_ric | character varying(250) |
num_allegati_ar | character varying(10) |
data_spedizione | date |
cod_ind | character varying(5) |
indirizzo | character varying(250) |
estr_cdesc_as | character varying(5) |
estr_atto_sped | character varying(250) |
num_allegati_as | character varying(10) |
num_rif_prot_ar | character varying(10) |
num_rif_prot_as | character varying(10) |
class_arch_ar | character varying(20) |
class_arch_as | character varying(20) |
spese_postali_ar | double precision |
spese_postali_as | double precision |
cod_settore_ar | character varying(50) |
cod_settore_as | character varying(50) |
cod_operatore_ar | character varying(50) |
cod_operatore_as | character varying(50) |
Indici:
"protocolli_pkey" PRIMARY KEY, btree (anno_regist, num_ordine)
So, seems correct to me.
Seems that somewhere 'treat empty dates as null' is set, but... where?
Thanks.
--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.lanostrafamiglia.it/
Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN)
marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797
Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
http://www.lanostrafamiglia.it/index.php/it/sostienici/5x1000
(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
From | Date | Subject | |
---|---|---|---|
Next Message | Clemens Ladisch | 2019-07-22 13:26:07 | Re: ODBC Driver 9->11, troubles with dates/NULL... |
Previous Message | Яковлева Наталья Вадимовна | 2019-07-19 10:14:39 | Problem with DBLINK from Oracle to Postgresql |