| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Deepak <deepakdevan(at)gmail(dot)com> |
| Subject: | Re: ...Roll Back issue in PGSQL.. |
| Date: | 2008-06-23 00:41:10 |
| Message-ID: | 200806222041.10743.xzilla@users.sourceforge.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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) 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.
>
Well, wrapping the bits of table2 in a begin....exception block would allow
him to do what he wants.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2008-06-23 01:25:48 | Talking at New York PHP meeting |
| Previous Message | Alvaro Herrera | 2008-06-22 18:34:23 | Re: Backend Stats Enhancement Request |