Bug 162294 - Missing trigger on rhnErrata
Missing trigger on rhnErrata
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Other (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: James Slagle
Red Hat Satellite QA List
Depends On:
Blocks: 147875
  Show dependency treegraph
Reported: 2005-07-01 20:49 EDT by Mike McCune
Modified: 2007-10-23 22:12 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2005-07-05 16:43:25 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Mike McCune 2005-07-01 20:49:51 EDT
Recently something changed in the sat schema and we no longer seem to have a
trigger to automatically insert sysdate on RHNERRATA.LAST_MODIFIED.

This is causing a ton of the sat unit tests to fail and is inconsistent with the
other tables in our schema.
Comment 1 James Slagle 2005-07-05 16:43:25 EDT
A not null constraint was added to the last_modified column:

alter table rhnErrata modify ( last_modified constraint rhn_errata_last_mod_nn
not null );

Note You need to log in before you can comment on or make changes to this bug.