Konstantin Izmailov wrote: > I'm planning to use multiple statements via libpq. Before starting coding > I'm trying to understand are there any limitations on passing parameters. > E.g. would the following work: > PQexecParams(conn, "BEGIN;INSERT INTO tbl VALUES($1,$2);SELECT > lastval();SELECT * INTO AUDIT FROM (SELECT $3, 'tbl action', > lastval());COMMIT;", 3, ...);
No, because PQexecParams doesn't accept multiple SQL statements. Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general