Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

BUG: Schema option is not reflected #58

Open
alesmenzel opened this issue Nov 24, 2020 · 0 comments
Open

BUG: Schema option is not reflected #58

alesmenzel opened this issue Nov 24, 2020 · 0 comments

Comments

@alesmenzel
Copy link

alesmenzel commented Nov 24, 2020

The schema schema: 'xxx' is not reflected when used with ENV option inside the database.json file.

{
  "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! We accept bounties via Bountysource.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant