Skip site navigation (1) Skip section navigation (2)

Looking for (ORACLE) Autonomous transaction in POSTGRES...

From: Thomas SMETS - disposable add <duvelbier-tsmets(at)yahoo(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Looking for (ORACLE) Autonomous transaction in POSTGRES...
Date: 2006-07-16 16:16:42
Message-ID: 20060716161642.19868.qmail@web32710.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgadmin-support
 Dear,
 
 I am working on a big project (running on Oracle as too often).
 I was considering to propose to switch part of the DB to Postgres as there is no need to pay 
the hefty price for what we need.
 The only glitch is the lack of something similar to the AUTOMONOUS_TRANSACTION pragma in 
Oracle parlance. The reason is that we like to have things like Log4PLSQL / Log4J on all our code 
so that any error can be traced (and recoverd).
 
 When is something similar foreseen in PostgreSQL ... ?
 
 Tx,
 
 \T,

 p.s. : 
 http://www.postgresql.org/docs/8.0/static/plpgsql-porting.html#PLPGSQL-PORTING-EX4 was of 
little help to see how I could have someting similar to it

--  
Any fool can write code that a computer can understand.  
Good programmers write code that humans can understand.                                                    
Martin Fowler  

T. : +32 (0)2 742 05 94 
M. : +32 (0)497 44 68 12 
@  : duvelbier-tsmets(at)yahoo(dot)com 
Do you skype too ... (callto://tsmets/) ?

pgadmin-support by date

Next:From: Dave PageDate: 2006-07-20 09:37:13
Subject: pgAdmin III v1.4.3 released
Previous:From: Ludwig Isaac LimDate: 2006-07-16 06:02:05
Subject: Unable to Install pgadmin3-1.4.1-1.i686.rpm on Fedora Core 4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group