Обсуждение: migrating from progress dbms
hi, currently we are planning a migration from a progress db to postgresql, and want to know if somebody has done the same, and what issues have found during the process. right now, the first thing we encounter is the fact that (at least in jdbc) all the table and column names needs to be beteewn double quotation marks. another is the fact that in progress exist an array data type. well, thanks in advance for any help you could provide, and best regards.
Lots of folks migrate from Progress. It should be fine. --------------------------------------------------------------------------- miguel angel rojas aquino wrote: > hi, currently we are planning a migration from a progress db to > postgresql, and want to know if somebody has done the same, and what > issues have found during the process. > > right now, the first thing we encounter is the fact that (at least in > jdbc) all the table and column names needs to be beteewn double > quotation marks. another is the fact that in progress exist an array > data type. > > well, thanks in advance for any help you could provide, and best regards. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Also, see techdocs.postgresql.org for porting guiedes. Not sure if Progress is in there. --------------------------------------------------------------------------- miguel angel rojas aquino wrote: > hi, currently we are planning a migration from a progress db to > postgresql, and want to know if somebody has done the same, and what > issues have found during the process. > > right now, the first thing we encounter is the fact that (at least in > jdbc) all the table and column names needs to be beteewn double > quotation marks. another is the fact that in progress exist an array > data type. > > well, thanks in advance for any help you could provide, and best regards. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Theare are arrays inPostgresql too.
On Mon, 27 Jan 2003 15:15:50 -0500 pgsql-general-owner@postgresql.org wrote: > > right now, the first thing we encounter is the fact that (at least in > jdbc) all the table and column names needs to be beteewn double > quotation marks. > Don't use double quotes unless you are asking for trouble! Double quotes are used for case sensitive identifiers or identifiers with whitespace characters. Usage of these features is not a good idea. If you have found that you need them in queries, then your CREATE statements used case sensitive table/attribute names. This will be a continuous source of pain and I strongly recommend that you fix your CREATE statements. Christoph Dalitz