From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
Cc: | jm(at)poure(dot)com, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Mapping Oracle types to PostgreSQL types |
Date: | 2003-10-17 13:49:44 |
Message-ID: | 3F8FF378.4080600@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers |
Shridhar Daithankar wrote:
> Jean-Michel POURE wrote:
>
>> Dear friends,
>>
>> I would like to port Compiere CRM from Oracle to PostgreSQL (and
>> release it for free).
>>
>> At first I would like to convert the data schema. This is not
>> difficult as Compiere is written using portable types like NUMBER
>> (i,d) which can be replaced by NUMERIC (i,d), etc... A series of
>> Search/Replace is sufficiant. There are other solutions in Contrib to
>> connect to Oracle and export the data (Bruce). Don't blame me to
>> search in another (silly) direction...
>
>
> Rather than declaring numeric, create them as integer/float of
> appropriate size and add appropriate constraints. Numeric can be
> slower for large data load w.r.t native integers.
float is *not* an alternative to numeric. While integer or int8 should
be usable for NUMBER(i), the non-rounding precision of numeric is vital
for such an application.
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-10-17 14:05:16 | Re: Mapping Oracle types to PostgreSQL types |
Previous Message | Shridhar Daithankar | 2003-10-17 13:39:38 | Re: Mapping Oracle types to PostgreSQL types |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-10-17 13:50:07 | Re: Some thoughts about i/o priorities and throttling vacuum |
Previous Message | Shridhar Daithankar | 2003-10-17 13:39:38 | Re: Mapping Oracle types to PostgreSQL types |