Open incognick opened 6 years ago
I ran into the same issue as well. On ubuntu 18.01, go 1.10.1. Installed the cli using the go get command
I can repro this inside the cockroach sql shell with:
BEGIN TRANSACTION;
TRUNCATE schema_migrations;
INSERT INTO schema_migrations (version, dirty) VALUES (1, true);
COMMIT;
I'm having trouble running my first migration against a local cockroachdb instance. I created the initial migration. I ran it and I get the following error:
migrate -database postgresql://root@127.0.0.1:26257/main?sslmode=disable -path migrations up error: pq: relation "schema_migrations" does not exist in line 0: INSERT INTO "schema_migrations" (version, dirty) VALUES ($1, $2)
The table exists in the
main
database:Not sure why this isn't working. I installed using go get.
Thanks for this tool and any help you can provide!