insert into: NULL in date column

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: insert into: NULL in date column
Date: 2019-01-11 22:56:23
Message-ID: alpine.LNX.2.20.1901111449480.8922@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A table has this column definition:

next_contact date DEFAULT '2020-11-06'
CONSTRAINT valid_next_date
CHECK (next_contact >= CURRENT_DATE),

(and I don't know that it needs a default).

In an input statement that column is left empty ('') when there's no defined
date. When I try to input that table I get a format error:

psql:activities.sql:2: ERROR: invalid input syntax for type date: ""
LINE 2: ...reaction they''ve experienced environmental issues.','','');
^
and my web research has not shown me my error. Removing the check constraint
does not eliminate that error.

Please show me what I've done incorrectly.

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2019-01-11 23:05:51 Re: insert into: NULL in date column
Previous Message Michel Pelletier 2019-01-11 18:56:06 Re: Benchmark of using JSON to transport query results in node.js