Re: [HACKERS] ...Roll Back issue in PGSQL..

2008-06-22 Thread Robert Treat
On Friday 20 June 2008 12:19:03 Joshua D. Drake wrote: > 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) ever

Re: [HACKERS] ...Roll Back issue in PGSQL..

2008-06-20 Thread Joshua D. Drake
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 thi

[HACKERS] ...Roll Back issue in PGSQL..

2008-06-20 Thread Deepak
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 "tryexcep