#1346 duplicate unique keys in module db?
Closed: Fixed 5 years ago by praiskup. Opened 5 years ago by praiskup.

coprdb=# select * from pg_indexes where tablename = 'module';
 schemaname | tablename |             indexname              | tablespace |                                                       indexdef                                                       
------------+-----------+------------------------------------+------------+----------------------------------------------------------------------------------------------------------------------
 public     | module    | copr_name_stream_version_uniq      |            | CREATE UNIQUE INDEX copr_name_stream_version_uniq ON public.module USING btree (copr_id, name, stream, version)
 public     | module    | module_pkey                        |            | CREATE UNIQUE INDEX module_pkey ON public.module USING btree (id)
 public     | module    | unique_name_stream_version_copr_id |            | CREATE UNIQUE INDEX unique_name_stream_version_copr_id ON public.module USING btree (name, stream, version, copr_id)

copr_name_stream_version_uniq seems to be duplicate to unique_name_stream_version_copr_id.

the copr_name_stream_version_uniq seems to be properly handled in code
and migrations, so if one should be deleted then the other one

Metadata Update from @praiskup:
- Issue assigned to praiskup

5 years ago

Log in to comment on this ticket.

Metadata
Related Pull Requests
  • #1356 Merged 5 years ago
  • #1353 Merged 5 years ago