Re: PL/pgSQL: EXCEPTION NOSAVEPOINT

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Matt Miller <mattm(at)epx(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
Date: 2005-09-02 01:16:59
Message-ID: 4317A80B.9080807@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cristian Prieto 2005-09-02 02:23:31 Trouble with bytea in SPI...
Previous Message Tom Lane 2005-09-02 00:02:56 Re: Performance question (FOR loop)

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew Miller 2005-09-02 01:58:41 Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
Previous Message Ricardo Humphreys 2005-09-02 01:11:05 Avoid using swap in a cluster

Browse pgsql-patches by date

  From Date Subject
Next Message Jim C. Nasby 2005-09-02 04:34:37 Re: Version number in psql banner
Previous Message Bruce Momjian 2005-09-02 01:06:18 Re: [BUGS] PSQL commands not backwards-compatible