BUG: Schema option is not reflected
- Dominant language
- JavaScript
- Stars
- 68
- Forks
- 50
- PR merge metrics
- No merged PRs in 30d
Description
The schema `schema: 'xxx'` is not reflected when used with `ENV` option inside the `database.json` file.
```json
{
"dev": {
"ENV": "POSTGRES_CONNECTION_STRING",
"schema": "my_schema"
}
}
```
Here is the db-migrate/pg log:
```
[INFO] require: db-migrate-pg
[INFO] connecting
[INFO] connected
[SQL] show server_version_num
[SQL] SHOW search_path
[SQL] SET search_path TO "$user","public"
[SQL] SELECT table_name FROM information_schema.tables WHERE table_name = 'migrations' AND table_schema = 'public'
[INFO] creating table: migrations
[SQL] CREATE TABLE IF NOT EXISTS "migrations" ("id" SERIAL PRIMARY KEY NOT NULL, "name" VARCHAR (255) NOT NULL, "run_on" TIMESTAMP NOT NULL) << schema not reflected
```
---
Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/94647530-bug-schema-option-is-not-reflected?utm_campaign=plugin&utm_content=tracker%2F14258523&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F14258523&utm_medium=issues&utm_source=github).
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.