Skip to content

After finishing the PG logical tests with upgrade restore the identity initial from the following tables in staging

execute the following SQL :

select 'ALTER TABLE '||tab.table_schema||'.'||tab.table_name||' REPLICA IDENTITY NOTHING ;'

for the following tables :

 ALTER TABLE public.analytics_language_trend_repository_languages REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.approval_project_rules_protected_branches REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.ci_build_trace_sections REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.deployment_merge_requests REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.elasticsearch_indexed_namespaces REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.elasticsearch_indexed_projects REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.issue_assignees REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.issues_prometheus_alert_events REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.issues_self_managed_prometheus_alert_events REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.merge_request_context_commit_diff_files REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.merge_request_diff_commits REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.merge_request_diff_files REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.milestone_releases REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.my_table REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.pg_stat_statements_history REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.project_authorizations REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.project_pages_metadata REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.push_event_payloads REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.repository_languages REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.schema_migrations REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.truncate_test REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.user_interacted_projects REPLICA IDENTITY NOTHING ;
 ALTER TABLE public.users_security_dashboard_projects REPLICA IDENTITY NOTHING ;