"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
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 |