Re: PL/pgSQL: EXCEPTION NOSAVEPOINT - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
Date
Msg-id 4317A80B.9080807@familyhealth.com.au
Whole thread Raw
In response to Re: PL/pgSQL: EXCEPTION NOSAVEPOINT  (Matt Miller <mattm@epx.com>)
Responses Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
List pgsql-hackers
Why don't you just use EnterpriseDB?

Chris

> That would defeat my goal of not rewriting all my Oracle code.
> 
> If I were fool enough to plan an attack on the main executor's exception
> handling to try and disarm it of its subtransaction semantics, where
> would I start?  Where would I end?  What would I do in between?  Can New
> Orleans be rebuilt above sea level?
> 
> Seriously, though, I'm willing to devote considerable time to this.
> Rewriting all my Oracle code function-by-function could be painful, and
> I would end up dragging other people around this company into it.  I'm
> still trying to hold on to my fantasy that I can hack Postgres (and
> contrib/ora2pg) into submission.  In the end I'm hoping that the move
> from Oracle will be made easier for others.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings



pgsql-hackers by date:

Previous
From: Ricardo Humphreys
Date:
Subject: Avoid using swap in a cluster
Next
From: "Matthew Miller"
Date:
Subject: Re: PL/pgSQL: EXCEPTION NOSAVEPOINT