Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-18 Thread Jean-Paul ARGUDO
Le Friday Oct 17, 2003 at 10:10:26AM +0200, Jean-Michel POURE a écrit : Dear friends, I would like to port Compiere CRM from Oracle to PostgreSQL (and release it for free). Hi Jean-Michel, I did Red-Hat CCM Migration from Oracle to PostgreSQL a year ago when I was the dba of IdealX, a

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-18 Thread Jean-Michel POURE
Dear Jean-Paul, Please tell me if my experience can help you in any way, I'd be really glad in participating your project. Thanks for your proposal, welcome in the team. In short, we plan to port Compiere to PostgreSQL and submit the changes back to Compiere team. There is no evidence so far

[HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-17 Thread Jean-Michel POURE
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

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-17 Thread Peter Eisentraut
Jean-Michel POURE writes: Is there a way to map Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght) in PostgreSQL 7.3? Are there plans to allow such mapping in the future using the CREATE DOMAIN syntax? No to both. Doing this would most likely require making the affected type names be

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-17 Thread Shridhar Daithankar
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

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-17 Thread Andreas Pflug
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)

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-17 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Jean-Michel POURE writes: Is there a way to map Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght) in PostgreSQL 7.3? Are there plans to allow such mapping in the future using the CREATE DOMAIN syntax? No to both. Doing this would most likely

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-17 Thread Matthew T. O'Connor
On Fri, 2003-10-17 at 04:10, Jean-Michel POURE wrote: Dear friends, I would like to port Compiere CRM from Oracle to PostgreSQL (and release it for free). This would be wonderful. However, I believe the guys at Compiere tried to do this already and gave up on porting it to postgresql due

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-17 Thread Kris Jurka
On Fri, 17 Oct 2003, Tom Lane wrote: Since varchar(n) is SQL-standard syntax, can't you simply adopt the more standard name for both databases? A long time ago Oracle made the varchar type equivalent to char and once people complained about the excess space used by short entries they came

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

2003-10-17 Thread Jean-Michel POURE
Le Vendredi 17 Octobre 2003 16:32, Matthew T. O'Connor a crit : This would be wonderful. However, I believe the guys at Compiere tried to do this already and gave up on porting it to postgresql due too a couple of PostgreSQL limitations. I don't remember what they are exactly, I think it had