James Le Cuirot <ch...@aura-online.co.uk> writes: > Tom Lane <t...@sss.pgh.pa.us> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general