Scope Configuration doesn't work with Postgres

[Manny651]

Scope Configuration does not seem to work at all with PostgreSQL.

• If "database" is specified in the sub configuration (config.json), it generates an invalid statement:

ERROR: syntax error at or near "`" at character 20. STATEMENT: SET search_path TO `databaseName`

• If a "database" is not specified, the process freezes.

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[jwdinker]

is it hanging when it loads the migration subfolder?

[INFO] loaded extra config for migration subfolder: "hm_private/config.json"

[wzrdtales]

postgres is a lot different than other databases. can you post your config, then I can have a look and verify. What i think the issue is, that you specified database instead of schema in the config.

[Manny651]

I just looked at the code, and I see several issues in the switchDatabase function:

• Backticks are used as escape characters (instead of quotation marks)
• If the options object does not have a database field, the callback is never called
• It uses the database option to set the search path (instead of the schema).