Re: [GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-18 Thread Robert Treat
On Tuesday 17 October 2006 05:36, A. Kretschmer wrote:
 am  Tue, dem 17.10.2006, um 10:44:52 +0200 mailte Thomas Kellerer folgendes:
  On 17.10.2006 10:36 Andreas Kretschmer wrote:
  http://techdocs.postgresql.org/#convertfrom
 
  I just noticed that the link Porting from Oracle PL/SQL still points
  to the 7.4 manuals. Shouldn't that be updated to point to the current
  release?
 
  And the link Ora2Pg - Oracle to PostgreSQL database schema converter
 
  (http://techdocs.postgresql.org/redir.php?link=http://www.samse.fr/GPL/or
 a2pg/ora2pg.html)
 
  gives a 404 error.

 Sorry.


Not your fault...  the whole techdocs site really needs to go away but the pg 
webmasters haven't gotten around to it (mostly me in this particular case)

Felix, in case your still watching, a (in theory) more up to date link would 
be found at http://www.postgresql.org/docs/techdocs.3. Oh, and please don't 
crosspost across 3 different lists in the future, it just creates noise for 
the rest of us. 

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/


[GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-17 Thread Felix Zhang
Hi all,

I'm a newbie of PostgreSQL. I'm searching materials about porting from Oracle to PostgreSQL.
Anyone can share with me some good documatations?

Thanks and regards,
Felix


Re: [GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-17 Thread Andreas Kretschmer
Felix Zhang [EMAIL PROTECTED] schrieb:

 Hi all,
  
 I'm a newbie of PostgreSQL. I'm searching materials about porting from Oracle
 to PostgreSQL.
 Anyone can share with me some good documatations?

http://techdocs.postgresql.org/#convertfrom


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.  (Linus Torvalds)
If I was god, I would recompile penguin with --enable-fly.(unknow)
Kaufbach, Saxony, Germany, Europe.  N 51.05082°, E 13.56889°

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/


Re: [GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-17 Thread Thomas Kellerer

On 17.10.2006 10:36 Andreas Kretschmer wrote:


http://techdocs.postgresql.org/#convertfrom



I just noticed that the link Porting from Oracle PL/SQL still points 
to the 7.4 manuals. Shouldn't that be updated to point to the current 
release?


And the link Ora2Pg - Oracle to PostgreSQL database schema converter

(http://techdocs.postgresql.org/redir.php?link=http://www.samse.fr/GPL/ora2pg/ora2pg.html)

gives a 404 error.


Thomas


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/


Re: [GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-17 Thread Shane Ambler

Felix Zhang wrote:

Hi all,

I'm a newbie of PostgreSQL. I'm searching materials about porting from
Oracle to PostgreSQL.
Anyone can share with me some good documatations?

Thanks and regards,
Felix



A quick search of pgfoundry finds
http://pgfoundry.org/projects/orafce/
which may help.

Depending on your needs and plans have you looked at EnterpriseDB?
They claim to run most Oracle stuff straight up. Their free version will 
run on 1cpu with up to 4GB data and 1GB RAM.



--

Shane Ambler
[EMAIL PROTECTED]

Get Sheeky @ http://Sheeky.Biz

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-17 Thread A. Kretschmer
am  Tue, dem 17.10.2006, um 10:44:52 +0200 mailte Thomas Kellerer folgendes:
 On 17.10.2006 10:36 Andreas Kretschmer wrote:
 
 http://techdocs.postgresql.org/#convertfrom
 
 
 I just noticed that the link Porting from Oracle PL/SQL still points 
 to the 7.4 manuals. Shouldn't that be updated to point to the current 
 release?
 
 And the link Ora2Pg - Oracle to PostgreSQL database schema converter
 
 (http://techdocs.postgresql.org/redir.php?link=http://www.samse.fr/GPL/ora2pg/ora2pg.html)
 
 gives a 404 error.

Sorry.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: - Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [SQL][GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-17 Thread Lewis Cunningham
Felix,

You might want to look at EnterpriseDB, which is PostgreSQL with
Oracle compatibility extensions.

www.enterprisedb.com

LewisC


--- Felix Zhang [EMAIL PROTECTED] wrote:

 Hi all,
 
 I'm a newbie of PostgreSQL. I'm searching materials about porting
 from
 Oracle to PostgreSQL.
 Anyone can share with me some good documatations?
 
 Thanks and regards,
 Felix
 

---
Lewis R Cunningham

ItToolBox Blog: An Expert's Guide to Oracle 
http://blogs.ittoolbox.com/oracle/guide/

EnterpriseDB: The Definitive Reference
http://www.rampant-books.com/book_2007_1_enterprisedb.htm
--

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/