Thread: bigger problem

bigger problem

From

"Carlos Sousa"

Date:

11 November 2002, 12:57:33

in postgres database i created a table with a field like

create table (...)
(...)
var text default '' not null
(...)

now i need to import the data from this table into a oracle database
i used pg_dump

I altered the field data type to

(...)
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

thanks for your time and replay





_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail

Re: bigger problem

From

"Josh Berkus"

Date:

11 November 2002, 16:10:14

Carlos,

> in postgres database i created a table with a field like
> 
> create table (...)
> (...)
> var text default '' not null
> (...)
> 
> now i need to import the data from this table into a oracle database
> i used pg_dump
> 
> I altered the field data type to
> 
> (...)
> 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

This is a problem with your configuration of Oracle import.   See your
Oracle documentation; we cannot help you here.

-Josh Berkus

Re: bigger problem

From

Peter Eisentraut

Date:

11 November 2002, 18:07:02

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