James Le Cuirot <chewi@xxxxxxxxxxxxxxxxx> writes: > Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> PG is not capable of executing queries that are not in transactions, >> so yes, PQsendQuery will create a single-statement transaction if you >> haven't sent BEGIN. However, there's a huge difference for the >> purposes we're discussing here: PQsendQuery does not allow more than >> one SQL command in the string. So most of this discussion is >> irrelevant when you're going through that API. > Heh, are you sure? From the docs... > "Using PQsendQuery and PQgetResult solves one of PQexec's problems: If a > command string contains multiple SQL commands, the results of those > commands can be obtained individually." Oh, sorry, I was confusing that with the extended-query-mode API (PQexecParams). Yeah, PQsendQuery is like PQexec for this purpose --- the backend does not actually know the difference. regards, tom lane
