Re: pg_query transaction: auto rollback? begin or start?? commit or end???

Поиск
Список
Период
Сортировка
От Bill Wordsworth
Тема Re: pg_query transaction: auto rollback? begin or start?? commit or end???
Дата
Msg-id 1e07a2bd0807221040y6bac3eddpff7806a429db626a@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_query transaction: auto rollback? begin or start?? commit or end???  (Chris <dmagick@gmail.com>)
Список pgsql-general
...resending, email didn't go through.

On Tue, Jul 22, 2008 at 1:02 PM, Bill Wordsworth
<bill.wordsworth@gmail.com> wrote:
> Is this recommended?
>
> pg_query("begin transaction read write;", $connection);
> if(pg_transaction_status($connection) == 2) {
>        pg_query("insert...;", $connection);
>        pg_query("insert...;", $connection);
>        pg_query("insert...;", $connection);
> }
> pg_query("commit transaction;", $connection);
> pg_close($connection);
>
> Now *any* error inside transaction will trigger auto rollback for
> *all* inserts so I don't need to explicitly issue conditional
> rollback? Also is "begin/commit transaction" == "start/end
> transaction"??
> Cheers, Bill

В списке pgsql-general по дате отправления:

Предыдущее
От: Stefan Sturm
Дата:
Сообщение: Optimizing a like-cause
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Initdb problem on debian mips cobalt: Bus error