Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!feeder.erje.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: migrating oracle to postgres Date: Mon, 20 Jun 2011 22:37:03 +0000 (UTC) Organization: solani.org Lines: 20 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1308609423 10069 eJwNxcEBwCAIA8CVREiEdUhl/xHsfQ5Oo04QDAwmImsGrV5nNyb/IFKGuaVl3vJN1YebbfcBGyoROQ== (20 Jun 2011 22:37:03 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Mon, 20 Jun 2011 22:37:03 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwFwYEBACAEBMCV8HwaJ8n+I3QXoPIuZ9BjYsTrqCANPLjdGGnFM77yHiaM+/XKndUeNR8W1BEx Cancel-Lock: sha1:I06lnZYBPLZ5E56Vt9xcOWCrRIA= X-NNTP-Posting-Host: eJwFwYkBADAEBLCVKOcZh6r9R2gCMbbrajDFYslKb77upiQ/rnUeN60s8sHTyyciINOcI/IBG/UQ3Q== Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:136 On Mon, 20 Jun 2011 23:45:38 +0200, Username wrote: > Most of your critics on postgres refer to large amounts of data and > perfomance critical applications. In my scenario the oracle-db neither > uses hints or partitioned tables nor does performance matter that much. > I "only" have the problem of porting the 600k LOC PL/SQL application > logic (triggers, strored procedures etc.) to postgres. If that is the case, I would try mixing PlPgSQ with PLPerl. PlPgSQL is far inferior to PL/SQL. No packages, no procedures, but with Perl you can get it all. With the untrusted version, you can call external modules. Before you start: RAISE NOTICE is the PLPgSQL equivalent of dbms_output.put_line. -- http://mgogala.byethost5.com