Re: postgres crash on CURSORS

"Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> writes:
>> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>>>>> If we are in abort state and
>>>>> the submitted query string is
>>>>>
>>>>> SELECT foo ; ROLLBACK ; SELECT bar
>>>>>
>>>>> it seems to me that the correct response is to reject the first select
>>>>> and process the second.

> Unfortunately I've never used multiple query and understand
> little about it. For example,how to know using libpq that the first
> select was ignored ?

If you use PQexec then you can't really tell, because you'll only get
back the last command's result. If you use PQsendQuery/PQgetResult
then you'll get back multiple PGresults from a multi-query string, and
you can examine each one to see if it was executed or not.

regards, tom lane