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

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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Deepak <deepakdevan(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ...Roll Back issue in PGSQL..
Date: 2008-06-20 16:19:03
Message-ID: 1213978743.12706.0.camel@jd-laptop (view raw or flat)
Thread:
Lists: pgsql-hackers

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.

Joshua D. Drake

> 
> -- 
> Deepak 
> 


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-06-20 16:48:26
Subject: Re: Backend Stats Enhancement Request
Previous:From: Decibel!Date: 2008-06-20 16:14:47
Subject: Re: Doubt in index subplan query

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