transactions in plpgsql

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: transactions in plpgsql
Date: 2004-03-19 13:01:55
Message-ID: 200403191001.55604.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm building some functions in plpgsql, and I got to a point where I thought:
How are transactions used in the function? Is it posible to rollback the
modifications that were made to the tables at some point in the plpgsql
function?

--
09:58:01 up 10 days, 14:29, 4 users, load average: 0.11, 0.31, 0.32
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bas Scheffers 2004-03-19 13:03:35 Re: "People near me" query
Previous Message Stephen Frost 2004-03-19 13:00:26 Re: "People near me" query