Bugzilla (bugzilla.redhat.com) will be under maintenance for infrastructure upgrades and will not be available on July 31st between 12:30 AM - 05:30 AM UTC. We appreciate your understanding and patience. You can follow status.redhat.com for details.
Bug 162294 - Missing trigger on rhnErrata
Summary: Missing trigger on rhnErrata
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Other
Version: unspecified
Hardware: All
OS: Linux
Target Milestone: ---
Assignee: James Slagle
QA Contact: Red Hat Satellite QA List
Depends On:
Blocks: 147875
TreeView+ depends on / blocked
Reported: 2005-07-02 00:49 UTC by Mike McCune
Modified: 2007-10-24 02:12 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2005-07-05 20:43:25 UTC
Target Upstream Version:

Attachments (Terms of Use)

Description Mike McCune 2005-07-02 00:49:51 UTC
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 20:43:25 UTC
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.