Re: [HACKERS] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-09-02 Thread Matt Miller
Rewriting all my Oracle code function-by-function could be painful ... I'm still trying to hold on to my fantasy that I can hack Postgres (and contrib/ora2pg) into submission. Why don't you just use EnterpriseDB? I looked at EnterpriseDB a few months ago. The installation errored. It

Re: [HACKERS] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-09-02 Thread Alvaro Herrera
On Fri, Sep 02, 2005 at 02:34:50PM +, Matt Miller wrote: Rewriting all my Oracle code function-by-function could be painful ... I'm still trying to hold on to my fantasy that I can hack Postgres (and contrib/ora2pg) into submission. Why don't you just use EnterpriseDB? I

Re: [HACKERS] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-09-02 Thread Christopher Kings-Lynne
I looked at EnterpriseDB a few months ago. The installation errored. It left stuff in /var/opt, which I consider non-standard for a Red Hat machine. The whole product just didn't feel clean to me. I admit that's a pretty limited and subjective evaluation, especially for a beta product, but I

Re: [HACKERS] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-09-02 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: The EnterpriseDB guys have a final product now, and it's designed to emulate Oracle as much as possible. The question at hand is whether as much as possible includes having reinvented plpgsql's execution engine ... I have not seen their

Re: [HACKERS] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-09-02 Thread Josh Berkus
Matt, 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

Re: [HACKERS] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-09-01 Thread Tom Lane
[ redirected to -hackers, where it's actually on topic ] Matt Miller [EMAIL PROTECTED] writes: [redirected from -patches] On Wed, 2005-08-03 at 16:25 -0400, Tom Lane wrote: This fundamentally breaks the entire backend. You do not have the option to continue processing after elog(ERROR);

Re: [HACKERS] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-09-01 Thread Matt Miller
On Thu, 2005-09-01 at 18:28 -0400, Tom Lane wrote: Matt Miller [EMAIL PROTECTED] writes: Basically I'd like my Pl/pgSQL code to be able to utilize the try/catch paradigm of error handling without the overhead of subtransactions [Pl/pgSQL] can't even do 2+2 without calling the main

Re: [HACKERS] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-09-01 Thread Tom Lane
Matt Miller [EMAIL PROTECTED] writes: 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? In