...Roll Back issue in PGSQL.. - Mailing list pgsql-hackers

From Deepak
Subject ...Roll Back issue in PGSQL..
Date
Msg-id f60059d0806200040m7c363675h8a4e676ae929da0a@mail.gmail.com
Whole thread Raw
Responses Re: ...Roll Back issue in PGSQL..  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
<br /><span class="gmail_quote"><br /></span>Hi<br /><br />I am trying to create a TRIGGER function,that populates
valuesto another table upon inserting a value into a table. The issue is,if there is a exception(in Table 2) everything
getsrolled back including Table1.I dont want this to happen.i want the value of table1 to stay.<br /> I tried
"try....except"and introduced SAVEPOINT.But resulted in runtime error. <br /><br />Can anyone please help me out<br
clear="all"/><br />-- <br /><span class="sg">Deepak </span><br clear="all" /><br /> 

pgsql-hackers by date:

Previous
From: Suresh
Date:
Subject: Doubt in index subplan query
Next
From: Thomas Lee
Date:
Subject: Re: Backend Stats Enhancement Request