Re: ...Roll Back issue in PGSQL..

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Deepak <deepakdevan(at)gmail(dot)com>
Subject: Re: ...Roll Back issue in PGSQL..
Date: 2008-06-23 00:41:10
Message-ID: 200806222041.10743.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Friday 20 June 2008 12:19:03 Joshua D. Drake wrote:
> On Fri, 2008-06-20 at 13:10 +0530, Deepak wrote:
> > Hi
> >
> > I am trying to create a TRIGGER function,that populates values to
> > another table upon inserting a value into a table. The issue is,if
> > there is a exception(in Table 2) everything gets rolled back including
> > Table1.I dont want this to happen.i want the value of table1 to stay.
> > I tried "try....except" and introduced SAVEPOINT.But resulted in
> > runtime error.
> >
> > Can anyone please help me out
>
> The function executed by the trigger will be executed as a single
> transaction. If any part fails, they all fail.
>

Well, wrapping the bits of table2 in a begin....exception block would allow
him to do what he wants.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-06-23 01:25:48 Talking at New York PHP meeting
Previous Message Alvaro Herrera 2008-06-22 18:34:23 Re: Backend Stats Enhancement Request