<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/postgresql.git/contrib/oracle, branch master</title>
<subtitle>git.postgresql.org: git/postgresql.git
</subtitle>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/'/>
<entry>
<title>Remove ora2pg; now available at &lt;http://www.samse.fr/GPL/ora2pg/&gt;.</title>
<updated>2006-02-25T19:18:58+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter_e@gmx.net</email>
</author>
<published>2006-02-25T19:18:58+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=e6917b125599722ff2d2c861a4af1291f8a4da5e'/>
<id>e6917b125599722ff2d2c861a4af1291f8a4da5e</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Triggers should return TRIGGER not OPAQUE.  Looks like this script got</title>
<updated>2004-12-30T00:30:40+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2004-12-30T00:30:40+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=1ade4b33f6357a1491bd95b3a8340c2b3bded31f'/>
<id>1ade4b33f6357a1491bd95b3a8340c2b3bded31f</id>
<content type='text'>
overlooked in 7.3 updates.  Not a critical fix but avoids a notice when
the resulting SQL script is executed.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
overlooked in 7.3 updates.  Not a critical fix but avoids a notice when
the resulting SQL script is executed.
</pre>
</div>
</content>
</entry>
<entry>
<title>Upgrade to even newer ora2pg 2.0.</title>
<updated>2003-01-07T22:17:14+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2003-01-07T22:17:14+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=a24104eb5eeca171aec6e4c059f44ffdf7b80c77'/>
<id>a24104eb5eeca171aec6e4c059f44ffdf7b80c77</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Upgrade to ora2pg 1.10.  Backpatch to 7.3.X.</title>
<updated>2003-01-07T22:15:56+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2003-01-07T22:15:56+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=ffab4fdf248ab41312d28d5c5bb9b5046d1c30eb'/>
<id>ffab4fdf248ab41312d28d5c5bb9b5046d1c30eb</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add a bunch of pseudo-types to replace the behavior formerly associated</title>
<updated>2002-08-22T00:01:51+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2002-08-22T00:01:51+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=b663f3443ba096a06970214c3e83e79f6e570b84'/>
<id>b663f3443ba096a06970214c3e83e79f6e570b84</id>
<content type='text'>
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 ...
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
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 ...
</pre>
</div>
</content>
</entry>
<entry>
<title>Remove the last traces of datatypes datetime and timespan.</title>
<updated>2002-05-03T04:11:08+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2002-05-03T04:11:08+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=8338cc03a8915e28024981d09193612ec4a83819'/>
<id>8338cc03a8915e28024981d09193612ec4a83819</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Update to new version of Oracle conversion utility, version 1.8.</title>
<updated>2002-04-04T05:55:57+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2002-04-04T05:55:57+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=d61c7886e8ab700872cebee9e4bcf9dccc2925f8'/>
<id>d61c7886e8ab700872cebee9e4bcf9dccc2925f8</id>
<content type='text'>
Gilles DAROLD
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Gilles DAROLD
</pre>
</div>
</content>
</entry>
<entry>
<title>Here the latest version and first working release of Ora2Pg a tool to export</title>
<updated>2001-06-23T02:56:23+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2001-06-23T02:56:23+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=2e2d17ed51a478dce46400cd23dfa0889c57b592'/>
<id>2e2d17ed51a478dce46400cd23dfa0889c57b592</id>
<content type='text'>
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
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
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
</pre>
</div>
</content>
</entry>
<entry>
<title>Update to ora2pg 1.2.</title>
<updated>2001-05-13T02:10:00+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2001-05-13T02:10:00+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=904ba3ff69e1402bc2042807fd1d37f8570bfea1'/>
<id>904ba3ff69e1402bc2042807fd1d37f8570bfea1</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add oracle conversion utility ora2pg in /contrib/oracle.</title>
<updated>2001-05-10T15:51:05+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2001-05-10T15:51:05+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=0d2c4d5a172f8cdc510abf32ef7ccc1c002267aa'/>
<id>0d2c4d5a172f8cdc510abf32ef7ccc1c002267aa</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
