Обсуждение: Errors loading null dates in 7.0beta1

Поиск
Список
Период
Сортировка

Errors loading null dates in 7.0beta1

От
Colin Rothnie
Дата:
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

От
Tom Lane
Дата:
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