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

No comments: