pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Marian POPESCU <softexpert@libertysurf.fr>
To: pgsql-sql@postgresql.org
Subject: transaction in function
Date: Tue, 05 Dec 2006 16:25:31 +0100
Message-ID: <el431c$9mt$1@sea.gmane.org> (raw)

Hi,

I want to write a function that updates several tables; if there is an
exception while updating, it should rollback the transaction and raise an
error.

How can this be done in pgPLSQL in PostgreSQL 8.1 ?

Thank you for helping me out on this one !





view thread (4+ messages)  latest in thread

Message-ID: <el431c$9mt$1@sea.gmane.org>
Permalink:  ../el431c$9mt$1@sea.gmane.org/
Also on:    postgresql.org/message-id/el431c$9mt$1@sea.gmane.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: softexpert@libertysurf.fr
  Subject: Re: transaction in function
  In-Reply-To: <el431c$9mt$1@sea.gmane.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox