Re: Transaction Rollback problen (3.0 Protocol) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Transaction Rollback problen (3.0 Protocol)
Date
Msg-id 12798.1069432097@sss.pgh.pa.us
Whole thread Raw
In response to Transaction Rollback problen (3.0 Protocol)  (Carlos Guzmán Álvarez <carlosga@telefonica.net>)
Responses Re: Transaction Rollback problen (3.0 Protocol)  (Carlos Guzmán Álvarez <carlosga@telefonica.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: logical column position
Next
From: Tom Lane
Date:
Subject: Anyone working on pg_dump dependency ordering?