Hi Jaemin, You can try to post this question on stack overflow, but why don't you use PostgreSQL this is recommended. SQLite as the name implies it's more for testing purpose in a small project environment. //Jona
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Wed, Aug 21, 2019 at 2:48 PM Jaemin Noh <korsn...@korsnack.kr> wrote: > Hello. > > My application is currently in a development state, so it's using SQLite > as a database backend at the moment. > > Due to the bad design decisions, my application has a migration with raw > CREATE VIEW statements and unmanaged models. These VIEWs refer other tables > with JOIN clauses. > The problem is, when a column is being added to or removed from a table > with a migration, Django remakes table( > https://github.com/django/django/blob/1e429df748867097451bf0b45d1080ae6828d921/django/db/backends/sqlite3/schema.py#L320-L346), > and VIEW throws a 'no such table' error when joined table is being deleted. > > Maybe this is SQLite's problem since table is being deleted inside a > transaction and this should not cause any problem in theory. Maybe it can > be fixed in Django to use ALTER TABLE statement. > Ultimately, I can just get away with this problem if I switch to MySQL or > PostgreSQL. > > So, what should I do? Where should I report this 'bug' or 'problem'? > SQLite? Django? > > Thanks in advance. > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/21c59661-bdba-43f6-9551-de1a6bf278de%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/21c59661-bdba-43f6-9551-de1a6bf278de%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAD9jLPLTvpG%3D1-Psj%2BxdfORgy1ASov-Ue6RDU8UiwRNGM6tk1w%40mail.gmail.com.
