Re: Transaction Rollback problen (3.0 Protocol)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Transaction Rollback problen (3.0 Protocol)
Дата
Msg-id 12798.1069432097@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Transaction Rollback problen (3.0 Protocol)  (Carlos Guzmán Álvarez <carlosga@telefonica.net>)
Ответы Re: Transaction Rollback problen (3.0 Protocol)
Список pgsql-hackers
Carlos Guzmán Álvarez <carlosga@telefonica.net> writes:
> After send the rollbact transaction command i'm not receiving any 
> response from the server, instead, if the SQL command is a valid SQL 
> command all runs fine, any idea about what can be the problem ??

Are you using the extended query protocol?  If so you probably have
forgotten the need for a Sync message.  After an error, the server
discards frontend messages until it sees a Sync.  This is needed so that
you can fire off several component messages in an extended-query
operation without waiting to see whether each one succeeds.  You put the
Sync at the point where you want to wait for results.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: logical column position
Следующее
От: Tom Lane
Дата:
Сообщение: Anyone working on pg_dump dependency ordering?