Changeset 6ea1dad6f00d20ef52591c282ffc9b1e002d5420

Show
Ignore:
Timestamp:
05/24/08 00:33:16 (6 years ago)
Author:
Theo Schlossnagle <jesus@omniti.com>
git-committer:
Theo Schlossnagle <jesus@omniti.com> 1211589196 +0000
git-parent:

[de852c9d34655dd3ed1d4bd8e101f9c27231c0a6]

git-author:
Theo Schlossnagle <jesus@omniti.com> 1211589196 +0000
Message:

Oops.. This caused every line in loading_dock_status_s to be considered as a change

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/schema.sql

    r197579c r6ea1dad  
    221221IF TG_OP = 'INSERT' THEN 
    222222    SELECT state,availability FROM  stratcon.loading_dock_status_s WHERE sid = NEW.sid  
    223         AND WHENCE = (SELECT max(whence) FROM stratcon.loading_dock_metric_text_s_change_log  
     223        AND WHENCE = (SELECT max(whence) FROM stratcon.loading_dock_status_s_change_log  
    224224                        WHERE  SID=NEW.sid and  WHENCE <> NEW.whence ) 
    225225    INTO v_state,v_avail;