Changeset be8707fb024addfa6eb855a9d160e6f2b5afec3f

Show
Ignore:
Timestamp:
05/14/08 18:45:06 (6 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1210790706 +0000
git-parent:

[2d2a01235fc4b87f4d1046e89762367af33f539d]

git-author:
Denish Patel <denish@omniti.com> 1210790706 +0000
Message:

Replace TIMESTAMP with TIMESTAMPTZ.

Files:

Legend:

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

    r152d473 rbe8707f  
    66    sid integer NOT NULL, 
    77    remote_address inet, 
    8     whence timestamp NOT NULL, 
     8    whence timestamptz NOT NULL, 
    99    id uuid NOT NULL, 
    1010    target text NOT NULL, 
     
    1616CREATE TABLE stratcon.loading_dock_status_s ( 
    1717    sid integer NOT NULL, 
    18     whence timestamp NOT NULL, 
     18    whence timestamptz NOT NULL, 
    1919    state character(1) NOT NULL, 
    2020    availability character(1) NOT NULL, 
     
    2626CREATE TABLE stratcon.loading_dock_status_s_change_log ( 
    2727    sid integer NOT NULL, 
    28     whence timestamp NOT NULL, 
     28    whence timestamptz NOT NULL, 
    2929    state character(1) NOT NULL, 
    3030    availability character(1) NOT NULL, 
     
    3737CREATE TABLE stratcon.loading_dock_metric_text_s ( 
    3838    sid integer NOT NULL, 
    39     whence timestamp NOT NULL, 
     39    whence timestamptz NOT NULL, 
    4040    name text NOT NULL, 
    4141    value text, 
     
    4545CREATE TABLE stratcon.loading_dock_metric_text_s_change_log ( 
    4646    sid integer NOT NULL, 
    47     whence timestamp NOT NULL, 
     47    whence timestamptz NOT NULL, 
    4848    name text NOT NULL, 
    4949    value text, 
     
    5353CREATE TABLE stratcon.loading_dock_metric_numeric_s ( 
    5454    sid integer NOT NULL, 
    55     whence timestamp NOT NULL, 
     55    whence timestamptz NOT NULL, 
    5656    name text NOT NULL, 
    5757    value numeric, 
     
    6262    sid integer NOT NULL, 
    6363    name text NOT NULL, 
    64     rollup_time timestamp NOT NULL, 
     64    rollup_time timestamptz NOT NULL, 
    6565    count_rows integer, 
    6666    avg_value numeric, 
     
    7373    sid integer NOT NULL, 
    7474    name text NOT NULL, 
    75     rollup_time timestamp NOT NULL, 
     75    rollup_time timestamptz NOT NULL, 
    7676    count_rows integer, 
    7777    avg_value numeric, 
     
    8484   sid integer not null, 
    8585   name text not null,  
    86    rollup_time timestamp not null,  
     86   rollup_time timestamptz not null,  
    8787   count_rows integer, 
    8888   avg_value numeric , 
     
    9494   sid integer not null, 
    9595   name text not null,  
    96    rollup_time timestamp not null,  
     96   rollup_time timestamptz not null,  
    9797   count_rows integer, 
    9898   avg_value numeric , 
     
    104104   sid integer not null, 
    105105   name text not null,  
    106    rollup_time timestamp not null,  
     106   rollup_time timestamptz not null,  
    107107   count_rows integer, 
    108108   avg_value numeric , 
     
    118118 
    119119CREATE TABLE stratcon.log_whence_s ( 
    120     whence timestamp NOT NULL, 
     120    whence timestamptz NOT NULL, 
    121121    interval varchar2(20, 
    122122    PRIMARY KEY(whence,interval) 
     
    316316 rec stratcon.rollup_matrix_numeric_5m%rowtype; 
    317317 v_sql TEXT; 
    318  v_min_whence TIMESTAMP
    319  v_max_rollup_5 TIMESTAMP
    320  v_whence TIMESTAMP
     318 v_min_whence TIMESTAMPTZ
     319 v_max_rollup_5 TIMESTAMPTZ
     320 v_whence TIMESTAMPTZ
    321321 rows INT; 
    322322 v_nrunning INT; 
     
    412412 rec stratcon.rollup_matrix_numeric_20m%rowtype; 
    413413 v_sql TEXT; 
    414  v_min_whence TIMESTAMP
    415  v_max_rollup_20 TIMESTAMP
    416  v_whence TIMESTAMP
     414 v_min_whence TIMESTAMPTZ
     415 v_max_rollup_20 TIMESTAMPTZ
     416 v_whence TIMESTAMPTZ
    417417 rows INT; 
    418418 v_nrunning INT; 
     
    509509  rec stratcon.rollup_matrix_numeric_60m%rowtype; 
    510510  v_sql TEXT; 
    511   v_min_whence TIMESTAMP
    512   v_max_rollup_60 TIMESTAMP
    513   v_whence TIMESTAMP
     511  v_min_whence TIMESTAMPTZ
     512  v_max_rollup_60 TIMESTAMPTZ
     513  v_whence TIMESTAMPTZ
    514514  v_nrunning INT; 
    515515  v_self VARCHAR(22); 
     
    601601  rec stratcon.rollup_matrix_numeric_6hours%rowtype; 
    602602  v_sql TEXT; 
    603   v_min_whence TIMESTAMP
    604   v_max_rollup_6 TIMESTAMP
    605   v_whence TIMESTAMP
     603  v_min_whence TIMESTAMPTZ
     604  v_max_rollup_6 TIMESTAMPTZ
     605  v_whence TIMESTAMPTZ
    606606  v_nrunning INT; 
    607607  v_self VARCHAR(22); 
     
    694694  rec stratcon.rollup_matrix_numeric_12hours%rowtype; 
    695695  v_sql TEXT; 
    696   v_min_whence TIMESTAMP
    697   v_max_rollup_12 TIMESTAMP
    698   v_whence TIMESTAMP
     696  v_min_whence TIMESTAMPTZ
     697  v_max_rollup_12 TIMESTAMPTZ
     698  v_whence TIMESTAMPTZ
    699699  v_nrunning INT; 
    700700  v_self VARCHAR(22); 
     
    783783stratcon.fetch_varset(in_check uuid, 
    784784                       in_name text, 
    785                        in_start_time timestamp
    786                        in_end_time timestamp
     785                       in_start_time timestamptz
     786                       in_end_time timestamptz
    787787                       in_hopeful_nperiods int) 
    788788returns setof stratcon.loading_dock_metric_text_s_change_log as 
     
    791791  v_sid int; 
    792792  v_target record; 
    793   v_start_adj timestamp
     793  v_start_adj timestamptz
    794794  v_start_text text; 
    795795  v_next_text text; 
    796   v_end_adj timestamp
     796  v_end_adj timestamptz
    797797  v_change_row stratcon.loading_dock_metric_text_s_change_log%rowtype; 
    798798begin 
     
    873873 
    874874create or replace function 
    875 stratcon.choose_window(in_start_time timestamp
    876                        in_end_time timestamp
     875stratcon.choose_window(in_start_time timestamptz
     876                       in_end_time timestamptz
    877877                       in_hopeful_nperiods int, 
    878878                       out tablename text, 
     
    926926stratcon.fetch_dataset(in_check uuid, 
    927927                       in_name text, 
    928                        in_start_time timestamp
    929                        in_end_time timestamp
     928                       in_start_time timestamptz
     929                       in_end_time timestamptz
    930930                       in_hopeful_nperiods int, 
    931931                       derive boolean) 
     
    937937  v_target record; 
    938938  v_interval numeric; 
    939   v_start_adj timestamp
    940   v_end_adj timestamp
     939  v_start_adj timestamptz
     940  v_end_adj timestamptz
    941941  v_l_rollup_row stratcon.rollup_matrix_numeric_5m%rowtype; 
    942942  v_rollup_row stratcon.rollup_matrix_numeric_5m%rowtype;