Project

General

Profile

Bug #24002

no unique constraint to the name column on the roles table

Added by Jan Hutař 5 months ago. Updated 4 months ago.

Status:
Closed
Priority:
Normal
Category:
Database
Target version:
Difficulty:
Triaged:
No
Bugzilla link:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

Description of problem:

The role name is unique. However, this doesn't reflect in the underline db.

Version-Release number of selected component (if applicable):

6.3.1, also broken os 6.4.0 snap 7

How reproducible:

Easy

Steps to Reproduce:
1. su - postgres
2. psql foreman
3. insert into roles(name, origin) values('Access Insights Admin', 'redhat_access');

Actual results:

Duplicate records for 'Access Insights Admin'

Expected results:

No duplicate record.

Associated revisions

Revision 1de010fc (diff)
Added by Dominik Hlavac Duran 4 months ago

Fixes #24002 - Add index for unique role names

History

#1 Updated by Jan Hutař 5 months ago

  • Category set to Database

#3 Updated by Dominik Hlavac Duran 4 months ago

  • Triaged set to No
  • Assignee set to Dominik Hlavac Duran

#4 Updated by The Foreman Bot 4 months ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/5833 added

#5 Updated by Tomer Brisker 4 months ago

  • Bugzilla link set to 1589625

#6 Updated by Tomer Brisker 4 months ago

  • Target version set to 1.19.0
  • Fixed in Releases 1.19.0 added

#7 Updated by Dominik Hlavac Duran 4 months ago

  • % Done changed from 0 to 100
  • Status changed from Ready For Testing to Closed

Also available in: Atom PDF