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

From: Clemens Ladisch <clemens(at)ladisch(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: ODBC Driver 9->11, troubles with dates/NULL...
Date: 2019-07-22 13:26:07
Message-ID: d76c867b-1c76-9ec0-cb7b-57b7702fac96@ladisch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Marco Gaiarin 2019-07-22 14:00:58 Re: ODBC Driver 9->11, troubles with dates/NULL...
Previous Message Marco Gaiarin 2019-07-22 10:19:53 ODBC Driver 9->11, troubles with dates/NULL...