If you’re exporting an existing database with pg_dump and trying to use that exported SQL with diesel and your initial migration, even after diesel setup has been done and get this message:
Failed with: relation "__diesel_schema_migrations" does not exist
Then you likely have the following line in your postgreSQL dump:
|
1 |
SELECT pg_catalog.set_config('search_path', '', false); |
it needs to be changed to
|
1 |
SELECT pg_catalog.set_config('search_path', 'public', false); |
in order for the import to work.
Thank you for this, it saved the day 🙂