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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
