Re: [SQL] Errors loading null dates in 7.0beta1 - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Errors loading null dates in 7.0beta1
Date
Msg-id 24547.952504591@sss.pgh.pa.us
Whole thread Raw
In response to Errors loading null dates in 7.0beta1  (Colin Rothnie <colinr@tiwest.com.au>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Colin Rothnie
Date:
Subject: Errors loading null dates in 7.0beta1
Next
From: Colin Rothnie
Date:
Subject: FW: [SQL] Errors loading null dates in 7.0beta1