From: | "Eaglet" <Aquil8(at)infinito(dot)it> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org(dot)pgsql-admin(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org |
Subject: | handling exceptions, really not simple... :-(( |
Date: | 2001-11-14 11:51:30 |
Message-ID: | 9stld9$1cloc$1@news02.it.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers pgsql-sql |
Hi 2 everybody!
I'm evaluating a database that supports our 3-tier solutions, in addition to
Oracle.
Postgres is at the moment the candidate n. 1, but I realized it's very hard
to translate this type of code (Orqcle PL/SQL):
FUNCTION F_EXT(par1, par2 ...) RETURN.... IS
BEGIN
SAVEPOINT spF_EXT;
...[instructions]
INSERT INTO...
UPDATE...
DELETE...
...[instructions]
SAVEPOINT spF_INT;
ret := F_INT(par1, par2 ...);
IF ret = 'KO' THEN
ROLLBACK TO spF_EXT;
ELSE IF ret IS NULL THEN
ROLLBACK TO spF_INT;
END IF;
...[instructions]
COMMIT;
EXCEPTION
WHEN.....
...[instructions]
END F_EXT;
The goal to achieve is to trap every kind of execution errors without trying
to prevent their occurrence.
In any case, I usually can't be sure the function (F_EXT) works correcty: an
exception could be lanched by an internal function (F_INT), I couldn't know
to estabilish what happens and where ...
By the way, the evironment is:
the browser requests a PHP page that connect to a Data Source (Oracle) and
lanch a Stored Procedure; after the execution by Oracle, PHP get the result
and returns data or a message to the client.
It's very important for me to solve the application logic in the Back-End of
the system (Oracle or Postgres): integrity and meaning of function aren't
only "commit all" or "rollback all", and when something of wrong happens, I
need to know the type of exception and when it occurred. In Oracle I can do
this, but in Postgres I've not yet found anything of similar.
Can anyone help me?
Thanks in advance...
Eaglet
From | Date | Subject | |
---|---|---|---|
Next Message | Phill Kenoyer | 2001-11-14 17:11:53 | Re: installing |
Previous Message | tony | 2001-11-14 08:23:40 | Re: PostgreSQL->JDBC->Tomcat->Apache resource uses |
From | Date | Subject | |
---|---|---|---|
Next Message | Giuseppe Tanzilli - CSF | 2001-11-14 11:59:28 | Re: 7.2b2 problem using like 'XXX%' sequential scan |
Previous Message | Giuseppe Tanzilli - CSF | 2001-11-14 11:26:17 | 7.2b2 problem using like 'XXX%' sequential scan |
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Christophe Boggio | 2001-11-14 12:02:51 | Re: Optimization with dates |
Previous Message | Carl van Tast | 2001-11-14 09:28:38 | Re: Is this a bug? |