Re: ODBC Driver 9->11, troubles with dates/NULL...

Clemens Ladisch <[email protected]> Mon, 22 Jul 2019 15:26:07 +0200

Newsgroups	gmane.comp.db.postgresql.odbc
Message-ID	<[email protected]>

Marco Gaiarin wrote:
> ERRORE:  sintassi di input non valida per il tipo date: ""
> ISTRUZIONE:  INSERT INTO PROTOCOLLI ( ... DATA_REGIST ...) VALUES ( ... E'' ... )
>
> while the table expect a non-NULL:
>
>                Tabella "public.protocolli"
>      Colonna      |          Tipo          | Modificatori
> ------------------+------------------------+--------------
> ...
>  data_regist      | date                   | non null

Why are you mentioning NULL?  This is an empty string, which is not a valid date.

Are you sure that the ODBC driver version makes a difference?
Where should a valid date value come from, if not from the application?

Regards,
Clemens