| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Carlos Guzmán Álvarez <carlosga(at)telefonica(dot)net> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Transaction Rollback problen (3.0 Protocol) |
| Date: | 2003-11-21 16:28:17 |
| Message-ID: | 12798.1069432097@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
=?ISO-8859-1?Q?Carlos_Guzm=E1n_=C1lvarez?= <carlosga(at)telefonica(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-11-21 16:40:10 | Anyone working on pg_dump dependency ordering? |
| Previous Message | Tom Lane | 2003-11-21 16:08:42 | Re: logical column position |