Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2006-02-25Remove ora2pg; now available at <http://www.samse.fr/GPL/ora2pg/>.Peter Eisentraut
2004-12-30Triggers should return TRIGGER not OPAQUE. Looks like this script gotTom Lane
overlooked in 7.3 updates. Not a critical fix but avoids a notice when the resulting SQL script is executed.
2003-01-07Upgrade to even newer ora2pg 2.0.Bruce Momjian
2003-01-07Upgrade to ora2pg 1.10. Backpatch to 7.3.X.Bruce Momjian
2002-08-22Add a bunch of pseudo-types to replace the behavior formerly associatedTom Lane
with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ...
2002-05-03Remove the last traces of datatypes datetime and timespan.Tom Lane
2002-04-04Update to new version of Oracle conversion utility, version 1.8.Bruce Momjian
Gilles DAROLD
2001-06-23Here the latest version and first working release of Ora2Pg a tool to exportBruce Momjian
Oracle database to PostgreSQL. It currently dump the database schema (tables, views, sequences, indexes, grants), with primary, unique and foreign keys into PostgreSQL syntax without editing the SQL code generated. You can dump only a particular schema from the Oracle database. Functions, procedures and triggers with SQL or PLSQL code generated must be reviewed to match the PostgreSQL syntax. Some usefull recommandation on porting Oracle to PostgreSQL can be found at http://techdocs.postgresql.org/ under the "Converting from other Databases to PostgreSQL" Oracle part. I just notice one thing more is that the trunc() function in Oracle is the same for number or date so be carefull when porting to PostgreSQL to use trunc() for number and date_trunc() for date. I will add more precision in type NUMBER conversion based on length to match as closest as possible all rich PostgreSQL numerics type. But it seems not to be urgent as it seems that Oracle DBAs only create number with length 22 (default) Space seems not to be their problem... Gilles DAROLD
2001-05-13Update to ora2pg 1.2.Bruce Momjian
2001-05-10Add oracle conversion utility ora2pg in /contrib/oracle.Bruce Momjian