[GitHub] [incubator-superset] rob05c commented on issue #3829: Cannot create table with same name from a different datasource

[GitBox <gi...@apache.org>]

rob05c commented on issue #3829:
URL: https://github.com/apache/incubator-superset/issues/3829#issuecomment-714731915


   I just hit the same issue, with the default sqlite metadata source. Fixed it in sqlite3 with
   
   ```
   $ sqlite3 ~/.superset/superset.db
   ```
   
   ```
   CREATE TABLE "tables2" (
   ⋮ 
           UNIQUE (table_name, database_id),
   ⋮ 
   ;
   insert into tables2 select * from tables;
   drop table tables;
   alter table tables2 rename to tables;
   ```
   
   Seems like it isn't fixed in the latest stable version, which just needs `UNIQUE (table_name),` changed to `UNIQUE (table_name, database_id),`.
   
   ```
   $ superset version
   Superset 0.37.2
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org