I suggest you ...

Autonomous transaction like oracle in pl/pgsql

Add this feature for implementing logging in procedure/function.
see http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/autonotransaction_pragma.htm

149 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Ruslan Y. shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    started  · 

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Darren Duncan commented  ·   ·  Flag as inappropriate

        In a more general sense, autonomous transaction support is valuable because that goes a long way to being able to support a multi-process virtual machine in a DBMS, where one can effectively start a new "database connection" working parallel to others, but this is started by code within the DBMS rather than having to be by code externally. So good for computational completeness.

      Feedback and Knowledge Base