fixing boolean "is_disabled" column in "users" table

wbh1 / grafana-sqlite-to-postgres

Grafana SQLite to Postgres Database Migrator

MIT License

97 stars 26 forks source link

Closed twiesenthal closed 4 years ago

twiesenthal commented 4 years ago

fixing boolean "is_disabled" column in "users" table when migrating from sqlite to pgsql for Grafana version 6.4.1.

pq: column "is_disabled" is of type boolean but expression is of type integer INSERT INTO "user" - failed to import dump file to Postgres.

twiesenthal commented 4 years ago

thanks to @CozyBadger for suggesting this fix.

twiesenthal commented 4 years ago

@wbh1 argh, sorry for that. removed the binary from the commit history.