Project

General

Profile

Actions
Copy link

Bug #24002

closed

no unique constraint to the name column on the roles table

Added by Jan Hutař about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Dominik Hlavac Duran
Category:
Database
Target version:
1.19.0
Difficulty:
Triaged:
No
Bugzilla link:
1589625
Pull request:
https://github.com/theforeman/foreman/pull/5833
Fixed in Releases:
1.19.0
Found in Releases:
Red Hat JIRA:

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.

Actions
Copy link
 #1

Updated by Jan Hutař about 6 years ago

  • Category set to Database
Actions
Copy link
 #3

Updated by Dominik Hlavac Duran about 6 years ago

  • Assignee set to Dominik Hlavac Duran
  • Triaged set to No
Actions
Copy link
 #4

Updated by The Foreman Bot about 6 years ago

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

Updated by Tomer Brisker about 6 years ago

  • Bugzilla link set to 1589625
Actions
Copy link
 #6

Updated by Tomer Brisker about 6 years ago

  • Target version set to 1.19.0
  • Fixed in Releases 1.19.0 added
Actions
Copy link
 #7

Updated by Dominik Hlavac Duran about 6 years ago

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

Also available in: Atom PDF