Comments (3)
That would be an unfortunate occurrence. Changing the type of versionTable
would be a breaking interface change -- so I would prefer to avoid that. However, I will change the default from "schema_version" to "public.schema_version".
from tern.
I've just pushed v1.9.0
. New uses of the CLI should avoid this issue. I also added a comment to the NewMigrator[Ex]
functions recommending fully qualifying the version table name.
from tern.
Another option to more fully guard against that situation would be to inspect the database and see if there is already a version table in a different schema.
....
Actually, wait a second. In your original scenario, in step 3 the original schema_version
table is still visible in the search path. Why is it not just using that?
....
That's the problem... create table if not exists
is looking at the top of the search path instead of seeing if a table by that name is visible at all.
So I guess it might be fair to add a check to ensureSchemaVersionTableExists
to detect the version table instead of relying on create table if not exists
.
...
Okay. Just released v1.9.1
with ensureSchemaVersionTableExists
checking for existence of the version table anywhere in the search path instead of only the top. This should resolve the problem regardless of fully qualifying the version table name.
from tern.
Related Issues (20)
- Another approach to conflicting migrations HOT 3
- Feature: Docker image HOT 4
- Running migrations in a schema HOT 2
- Wrapping migration files in transactions HOT 2
- Security vulnerability detected in current stable version HOT 2
- Configurable amount of leading 0s for migration files HOT 5
- port ignored in tern.conf HOT 8
- Add migrations path to config HOT 5
- New release with version using pgx v5? HOT 11
- Purpose of MigratorOptions.FileSystem (v2-dev) HOT 3
- Pre-built binaries HOT 1
- pre-/post-migration hooks from Go package HOT 3
- How to load .env file variables in tern.config HOT 1
- Dependency-based or git-based conflict resolution HOT 2
- ssh-tunnel port not being respected from config HOT 1
- Migrating from another migration tool HOT 2
- Ability to mask created user's passwords HOT 1
- runtime error: invalid memory address or nil pointer dereference HOT 2
- Do not use a schema for expressing the schema version table HOT 7
- Need V2 release with gengen feature HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tern.