How to execute an SQL file?

[gajus]

This has been asked before (e.g. #1763), and the answer was to just use query(). However, this no longer seems to work:

severity: ERROR
code:     42601
file:     postgres.c
line:     1400
routine:  exec_parse_message
name:     Error
message:  cannot insert multiple commands into a prepared statement

This is at least the case with the native driver.

What is the correct way to split SQL file by query and execute it?

StackOverflow suggests adhoc implementations such as this: https://stackoverflow.com/a/22659240/368691 However, they are utterly unsafe (any SQL that includes ; will break).

[charmander]

query should still work. Can you try it with the JS driver?

[gajus]

It does work with the JavaScript driver, but it does not work with the native driver.

[charmander]

What does your query call look like? I looked at the path through pg, pg-native, and node-libpq, and it seems like it’s making the distinction and switching between PQsendQuery and PQsendQueryParams as it should.

[gajus]

The stack trace is cut off:

Error: cannot insert multiple commands into a prepared statement
  at module.exports.Client._emitResult (/Users/gajus/Documents/dev/[..]/node_modules/pg-native/index.js:173:26)
  at module.exports.Client._read (/Users/gajus/Documents/dev/[..]/node_modules/pg-native/index.js:215:31)
  at PQ.emit (events.js:321:20)
  at PQ.EventEmitter.emit (domain.js:485:12)

[charmander]

I mean the code. pool.query(…)?

[gajus]

Like, the actual query that was executed? It is the contents of a pg_dump produced SQL.

[gajus]

It looks like:

pool.query('CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public; CREATE EXTENSION IF NOT EXISTS pgstattuple WITH SCHEMA public;');

is enough to reproduce the issue.