Bug 1147379

Description of problem:

* delete the puppet manifest out of the satellite server WebUI:
--> Configure --> Puppet classes
--> customntpd: delete

ERROR: update or delete on table "puppetclasses" violates foreign key constraint "environment_classes_puppetclass_id_fk" on table "environment_classes" DETAIL: Key (id)=(1) is still referenced from table "environment_classes".

After manually removing the references from the DB, the removal of the puppet class in the WebUI works:

 foreman=> \d puppetclasses
 id                        | integer                     | not null default nextval('puppetclasses_id_seq'::regclass)
 name                      | character varying(255)      | 
 created_at                | timestamp without time zone | not null
 updated_at                | timestamp without time zone | not null
 hosts_count               | integer                     | default 0
 hostgroups_count          | integer                     | default 0
 global_class_params_count | integer                     | default 0
 lookup_keys_count         | integer                     | default 0

foreman=> \d environment_classes
 puppetclass_id | integer | not null
 environment_id | integer | not null
 id             | integer | not null default nextval('environment_classes_id_seq'::regclass)
 lookup_key_id  | integer | 


foreman=> SELECT * FROM puppetclasses;
  2 | ssh        | 2014-09-25 12:28:09.018393 | 2014-09-25 12:28:09.018393 |           0 |                0 |                 
        6 |                 0
  1 | customntpd | 2014-09-25 08:38:10.571618 | 2014-09-25 08:38:10.571618 |           3 |                1 |                 
        0 |                 0

foreman=> SELECT * FROM environment_classes WHERE puppetclass_id = '1';
              1 |              6 |  9 |              

foreman=> DELETE FROM environment_classes WHERE puppetclass_id = '1';
DELETE 1

foreman=> \q


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

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info: