Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA77563 for ; Wed, 8 Mar 2000 03:36:44 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id DAA24550; Wed, 8 Mar 2000 03:36:31 -0500 (EST) To: Colin Rothnie cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Errors loading null dates in 7.0beta1 In-reply-to: References: Comments: In-reply-to Colin Rothnie message dated "Wed, 08 Mar 2000 14:36:21 +0800" Date: Wed, 08 Mar 2000 03:36:31 -0500 Message-ID: <24547.952504591@sss.pgh.pa.us> From: Tom Lane Colin Rothnie 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