Re: bigger problem

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Carlos Sousa <carlosdsousa(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: bigger problem
Date: 2002-11-11 20:12:37
Message-ID: Pine.LNX.4.44.0211112004070.12428-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)gmx(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-11-11 20:12:59 Re: Permission on insert rules
Previous Message floyds 2002-11-11 19:25:16 parse bug