Re: trigger AFTER INSERT
| От | Josi Perez (3T Systems) |
|---|---|
| Тема | Re: trigger AFTER INSERT |
| Дата | |
| Msg-id | AANLkTimHqdW07smfqh4QG+6DEOBToqd_kFADPwNgq+0R@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: trigger AFTER INSERT (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: trigger AFTER INSERT
|
| Список | pgsql-admin |
Thank you for your answer.
Without considering the errors, the transaction should not start after the AFTER INSERT?
Josi Perez
#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 13px;}
Without considering the errors, the transaction should not start after the AFTER INSERT?
Josi Perez
2010/8/12 Tom Lane <tgl@sss.pgh.pa.us>
"Josi Perez (3T Systems)" <josiperez3t@gmail.com> writes:Sure, because the whole transaction is rolled back on error.
> If I write a trigger AFTER INSERT and I have one error in this trigger, the
> record (that I think was already inserted) is not inserted.
regards, tom lane
В списке pgsql-admin по дате отправления: