Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

PostgreSQL upper case schema names end up double quoted #1211

Closed
smohara opened this issue Feb 17, 2016 · 0 comments
Closed

PostgreSQL upper case schema names end up double quoted #1211

smohara opened this issue Feb 17, 2016 · 0 comments

Comments

@smohara
Copy link

@smohara smohara commented Feb 17, 2016

If the first element in the search_path is a quoted upper case string, the doGetCurrentSchemaName method will return this quoted string as the schema name. When the schema name is then used in the creation of the schema_version table, the resulting sql is
CREATE TABLE ""MYSCHEMA""."schema_version" (
"installed_rank" INT NOT NULL,
"version" VARCHAR(50),
"description" VARCHAR(200) NOT NULL,
"type" VARCHAR(20) NOT NULL,
"script" VARCHAR(1000) NOT NULL,
"checksum" INTEGER,
"installed_by" VARCHAR(100) NOT NULL,
"installed_on" TIMESTAMP NOT NULL DEFAULT now(),
"execution_time" INTEGER NOT NULL,
"success" BOOLEAN NOT NULL
) WITH (
OIDS=FALSE
)

@axelfontaine axelfontaine modified the milestones: Flyway 4.0, Flyway 4.1 Feb 17, 2016
@axelfontaine axelfontaine modified the milestones: Flyway 4.0.2, Flyway 4.1 Jun 8, 2016
axelfontaine added a commit to flyway/flywaydb.org that referenced this issue Jun 8, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.