Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 45BA0475B85 for ; Mon, 11 Nov 2002 15:07:02 -0500 (EST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 06C77475A3F for ; Mon, 11 Nov 2002 15:07:01 -0500 (EST) Received: (qmail 21873 invoked by uid 0); 11 Nov 2002 20:05:48 -0000 Received: from pd902f0e4.dip0.t-ipconnect.de (217.2.240.228) by mail.gmx.net (mp006-rz3) with SMTP; 11 Nov 2002 20:05:48 -0000 Date: Mon, 11 Nov 2002 21:12:37 +0100 (CET) From: Peter Eisentraut X-X-Sender: peter@localhost.localdomain To: Carlos Sousa Cc: pgsql-sql@postgresql.org Subject: Re: bigger problem In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/170 X-Sequence-Number: 10312 Carlos Sousa writes: > (...) > var varchar2(50) default '' not null > (...) > > but when i was importing the the table into the oracle database all the rows > with the field var='' were not inserted. > Is there a way to work this around Yes, don't use Oracle. In Oracle, '' is the same as null, so the constraint is not satisfied. -- Peter Eisentraut peter_e@gmx.net