Drizzle Team•15mo ago

push:sqlite creating weird tables

When I run push:sqlite, tables like __old_push_categories are created and are automatically refrenced from the other tables. Now when I do a normal insert, I get this error no such table: main.__old_push_categories

5 Replies

SPS | ShootmailOP•15mo ago

For almost every insert now tables are referncing these __old tables

proto: {
      message: 'SQLite error: no such table: main.__old_push_media',
      code: 'SQLITE_UNKNOWN'
    }

proto: {
      message: 'SQLite error: no such table: main.__old_push_media',
      code: 'SQLITE_UNKNOWN'
    }

This is creating a lot of problems lately. Every time I do a push, it fails because of these tables. Should I use migrations instead to avoid these problems?

rphlmr ⚡•15mo ago

I use push only on early stage/when i'm confortable with erasing all. Then I go to migration.

SPS | ShootmailOP•15mo ago

You are saying if i use migrations, i will not have these problems?

rphlmr ⚡•15mo ago

I'm more a Postgress user, but you should not have this with migration

SPS | ShootmailOP•15mo ago

Alright, will try this.

Gaming

Programming

push:sqlite creating weird tables