On 03/11/2014 12:40, Rowan Collins wrote:
> When using a one-shot call to query() with multiple statements (e.g.
> create temp table; populate temp table; select results) it's actually
> necessary with Postgres to switch on emulation, and for that
> emulation to allow multiple queries even though the DBMS wouldn't. We
> discovered this in moving from ext/postgres, where pg_query() doesn't
> attempt to prepare the query, so allows strings containing multiple
> statements. We therefore needed a compatible mode in order to switch
> to PDO.
Both pg_query and EMULATE_PREPARES in pdo_pgsql use PQexec, that allows
multiple statements being sent at once. Going from memory it is also
used with PGSQL_DISABLE_PREPARES (5.6+) if there are no bound parameters.
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/