"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
>> From: Tom Lane [mailto:tgl@sss.pgh.pa.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