Re: problems with transaction blocks
От | Chris Travers |
---|---|
Тема | Re: problems with transaction blocks |
Дата | |
Msg-id | 011f01c3d4f0$277abaa0$9100053d@winxp обсуждение исходный текст |
Ответ на | problems with transaction blocks ("Chris Ochs" <chris@paymentonline.com>) |
Ответы |
Re: problems with transaction blocks
|
Список | pgsql-general |
Transactions are atomic. What you are asking to do violates the whole concept of a transaction. You can, however, do these inserts outside of the transaction block. Best Wishes, Chris Travers ----- Original Message ----- From: "Chris Ochs" <chris@paymentonline.com> To: <pgsql-general@postgresql.org> Sent: Wednesday, January 07, 2004 7:52 AM Subject: [GENERAL] problems with transaction blocks > I want to do a series of inserts within a single transaction block, but with > postgresql if one insert fails, the whole block is aborted. Is there any > way to get around this behavior so that postgresql won't abort the entire > transaction if a single insert returns an error? > > Chris > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >
В списке pgsql-general по дате отправления: