"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

In response to

• RE: postgres crash on CURSORS at 2000-04-06 01:37:14 from Hiroshi Inoue

pgsql-hackers by date

Next:	From: Hiroshi Inoue	Date: 2000-04-06 23:38:41
	Subject: RE: 7.0 like selectivity
Previous:	From: Tom Lane	Date: 2000-04-06 20:35:00
	Subject: Re: 'on insert' rules and defaults