Friday, June 20, 2008
[HACKERS] ...Roll Back issue in PGSQL..
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
--
Deepak
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment