Libpq and transactions

Поиск
Список
Период
Сортировка
От Brijesh Shrivastav
Тема Libpq and transactions
Дата
Msg-id 491DC5F3D279CD4EB4B157DDD62237F404E27EFD@zipwire.esri.com
обсуждение исходный текст
Ответы Re: Libpq and transactions  (Tomasz Myrta <jasiek@klaster.net>)
Список pgsql-interfaces
Hi! 

I have a question about how transaction behaves in libpq library.
It is very clear in doc that PQexec treats each command (which could 
comprise of more than one sql command) as a single transactions. 
Does PQexecParams() and PQexecPrepared() also behaves the same?
Is there a way to send multiple sql commands separately through
libpq library and rollback if nth command fails. For example, Can I
insert 5 rows using PQexecParams() and rollback all 5 rows if
sixth insert fails?

Regards,
Brijesh


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgin.tcl pg_exec_prepared slow (was: Released...)
Следующее
От: Greg Stark
Дата:
Сообщение: Re: pgin.tcl pg_exec_prepared slow (was: Released...)