Drop only the tables in the public schema

heroku / django-heroku

[DEPRECATED] Do not use! See https://github.com/heroku/django-heroku/issues/56

BSD 3-Clause "New" or "Revised" License

459 stars 142 forks source link

Drop only the tables in the public schema #20

Closed sigmavirus24 closed 6 years ago

sigmavirus24 commented 6 years ago

Instead of dropping and recreating the entire public schema of a database, let's just drop the tables in the schema.

Closes gh-17

the-mace commented 5 years ago

In the Heroku CI this does not appear to work: Ran 96 tests in 251.904s OK (skipped=2) Traceback (most recent call last): File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py", line 82, in _execute return self.cursor.execute(sql) psycopg2.errors.SyntaxError: syntax error at or near "(" LINE 2: DROP TABLE ( ^