Thread: Errors loading null dates in 7.0beta1

Errors loading null dates in 7.0beta1

From
Colin Rothnie
Date:
I am unable to load data into version 7.0 beta1 when the date field is null.
The same data loaded into the same table structure in 6.5.3 without errors.

Is this problem likely to have been resolved by recent changes in the
snapshot version?

Thanks in advance
Colin Rothnie


Re: [SQL] Errors loading null dates in 7.0beta1

From
Tom Lane
Date:
Colin Rothnie <colinr@tiwest.com.au> writes:
> I am unable to load data into version 7.0 beta1 when the date field is null.
> The same data loaded into the same table structure in 6.5.3 without errors.

FWIW, I don't see any obvious problem:

regression=# create table foo (f1 int, f2 date);
CREATE
regression=# insert into foo values (42, null);
INSERT 686666 1
regression=# select * from foo;f1 | f2
----+----42 |
(1 row)

Can you be more specific about your problem?
        regards, tom lane