On Fri, 2008-06-20 at 13:10 +0530, Deepak wrote:
> 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
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 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|