slayerjain commented on issue #13775: URL: https://github.com/apache/superset/issues/13775#issuecomment-808092678
@yogeshkk so I found why this was happening. the `id` column type is `SERIAL` and that created sequences. In a healthy superset installation those sequences were present eg: ``` ab_permission_id_seq ab_view_menu_id_seq ab_role_id_seq ab_user_id_seq ab_register_user_id_seq ab_permission_view_id_seq ab_user_role_id_seq ab_permission_view_role_id_seq tables_id_seq clusters_id_seq dashboards_id_seq dbs_id_seq datasources_id_seq columns_id_seq metrics_id_seq slices_id_seq sql_metrics_id_seq table_columns_id_seq dashboard_slices_id_seq logs_id_seq url_id_seq css_templates_id_seq favstar_id_seq dashboard_user_id_seq slice_user_id_seq query_id_seq access_request_id_seq keyvalue_id_seq saved_query_id_seq annotation_layer_id_seq annotation_id_seq user_attribute_id_seq dashboard_email_schedules_id_seq slice_email_schedules_id_seq sqlatable_user_id_seq druiddatasource_user_id_seq tag_id_seq tagged_object_id_seq tab_state_id_seq table_schema_id_seq row_level_security_filters_id_seq rls_filter_roles_id_seq rls_filter_tables_id_seq alerts_id_seq alert_logs_id_seq alert_owner_id_seq sql_observations_id_seq cache_keys_id_seq report_schedule_id_seq report_execution_log_id_seq report_recipient_id_seq report_schedule_user_id_seq dynamic_plugin_id_seq ``` But after pg_dump, the sequences were missing along with the link (`column_default`) in respective tables. So it looks like this in my problematic setup: ``` ab_permission_id_seq ab_permission_view_id_seq ab_permission_view_role_id_seq ab_register_user_id_seq ab_role_id_seq ab_user_id_seq ab_user_role_id_seq ab_view_menu_id_seq ``` -- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
