root/trunk/sql


Mode:

Legend:

Added
Modified
Copied or renamed
Rev Chgset Date Author Log Message
(edit) @533 [533] 12/03/08 16:32:30 denish pg ddl update
(edit) @530 [530] 12/03/08 12:37:57 denish Added job to cleanup prism.saved_graphs table with saved_graphs=false.
(edit) @517 [517] 11/20/08 18:03:02 denish updated saved_graphs before i/u trigger function
(edit) @515 [515] 11/04/08 15:23:11 denish prism.saved_graphs triggers adjustments
(edit) @502 [502] 10/16/08 12:17:38 denish fixed ownership of tables
(edit) @478 [478] 10/14/08 15:00:42 denish updated remove_metric function
(edit) @472 [472] 10/13/08 17:12:29 denish another fix for saved graph serach
(edit) @471 [471] 10/13/08 14:13:40 denish Fixed sved graphs trigger
(edit) @464 [464] 10/07/08 10:29:57 denish pg ddl export
(edit) @460 [460] 09/26/08 17:14:54 denish Modified function and trigger for saved_graphs as it was messing up with …
(edit) @457 [457] 09/25/08 15:24:59 denish granted more privs to stratcon user
(edit) @456 [456] 09/25/08 12:07:48 denish implemented add/remove tags functionality for graphs and created function …
(edit) @452 [452] 09/24/08 21:18:36 denish added index
(edit) @449 [449] 09/24/08 16:45:15 denish Moved metric_tags from prism schema to stratcon and grant all table to …
(edit) @448 [448] 09/24/08 15:50:24 denish Added search and tags functionalities
(edit) @441 [441] 09/22/08 14:09:27 denish Full database dump
(edit) @440 [440] 09/22/08 14:00:45 denish pg ddl update-- alter schema statrcon owner to reconnoiter
(edit) @439 [439] 09/22/08 13:57:16 denish pg ddl update
(edit) @387 [387] 08/25/08 21:25:15 jesus refs #50
(edit) @386 [386] 08/25/08 20:24:40 jesus just use reconnoiter_ddl_dump.sql as the master
(edit) @365 [365] 08/11/08 16:58:43 denish dump stratcon schema
(edit) @361 [361] 08/03/08 15:23:21 jesus people are gonna need this crontab to see rollups
(edit) @345 [345] 07/12/08 11:13:51 jesus implement a materialized view on the most recent metric_text change (need …
(edit) @341 [341] 07/11/08 15:40:02 denish updated Reconniter DDL dump
(edit) @340 [340] 07/11/08 15:35:19 denish corrected error warning for stratcon.mv_loading_dock_check_s()
(edit) @336 [336] 07/10/08 14:34:28 jesus make the fetch_ procedures also accept sids
(edit) @335 [335] 07/10/08 12:49:20 denish added mv_loading_dock_check_s() trigger function and related …
(edit) @332 [332] 07/09/08 22:51:36 jesus fix bug in update config and revert the out-of-order text metric support …
(edit) @323 [323] 07/02/08 14:29:43 denish Exported Latest DDL dump
(edit) @315 [315] 07/01/08 10:14:22 jesus fix up insert function for config info, refs #26
(edit) @314 [314] 06/30/08 15:32:15 denish added node configuration tables and trigger.
(edit) @280 [280] 06/16/08 15:16:10 denish remove min/max values from rollup tables/functions.
(edit) @278 [278] 06/06/08 16:42:16 denish Exception handling UNIQUE_VIOLATION in log_whence_change_log function.
(edit) @274 [274] 06/06/08 13:57:15 denish exception handing on stratcon.loading_dock_metric_numeric_s_whence_log
(edit) @256 [256] 05/31/08 22:38:47 jesus fix PK
(edit) @252 [252] 05/30/08 16:42:07 denish Added DDL dump for reconnointer database
(edit) @251 [251] 05/30/08 16:33:26 denish Updated Text change log trigger function to log older data changes too.
(edit) @247 [247] 05/23/08 20:33:16 jesus Oops.. This caused every line in loading_dock_status_s to be considered as …
(edit) @242 [242] 05/22/08 17:11:14 denish Grants.
(edit) @241 [241] 05/22/08 17:08:22 denish Added Remove_mtric function;
(edit) @230 [230] 05/21/08 16:41:30 denish better handling NOTICE for running job.
(edit) @229 [229] 05/21/08 16:25:37 denish Updated roll ups functions to process all available records from …
(edit) @222 [222] 05/14/08 16:34:00 denish updated sequence ddl to start with 1.
(edit) @220 [220] 05/14/08 16:10:38 denish Added date_trunc('hour',rollup_time) index on 20m rollup tables so we can …
(edit) @217 [217] 05/14/08 14:45:06 denish Replace TIMESTAMP with TIMESTAMPTZ.
(edit) @215 [215] 05/14/08 11:31:43 denish stddev_value removed.
(edit) @211 [211] 05/13/08 20:54:13 jesus fix the triggers.. the row itself is called nam, the summary is …
(edit) @210 [210] 05/13/08 17:53:09 denish updated 6 hours and 12 hours roll up functions and modify column name for …
(edit) @208 [208] 05/12/08 12:10:25 denish Added metric_name_summary table and updated functions to insert rows to …
(edit) @207 [207] 05/12/08 11:05:32 denish fixed 20m rollup function and table.
(edit) @206 [206] 05/09/08 17:25:50 denish Created trigger on stratcon.loading_dock_status_s to log the entry if …
(edit) @205 [205] 05/09/08 16:53:07 denish fix 20 minutes rollup function.
(edit) @204 [204] 05/09/08 16:39:46 denish Updated whence column to timestamp instead of timestaptz. updated …
(edit) @203 [203] 05/09/08 14:03:15 jesus windowed retrieval functions
(edit) @190 [190] 04/16/08 17:05:40 denish modified rollup_time6/12 colums to rollup_time and changed functions …
(edit) @185 [185] 04/02/08 15:28:43 denish updated functions for rollups
(edit) @183 [183] 03/28/08 15:38:56 denish Final 5 minutes and 1 hour rollup functions
(edit) @182 [182] 03/28/08 15:12:13 denish Final 5 minutes and 1 hour rollup functions
(edit) @181 [181] 03/27/08 16:51:08 denish updated functions and removed odd for rollups
(edit) @180 [180] 03/27/08 16:05:16 denish updated functions for rollups
(edit) @179 [179] 03/26/08 18:02:44 denish updated functions for rollups
(edit) @176 [176] 03/21/08 15:56:26 denish Updated Schema Sql
(add) @150 [150] 03/05/08 23:55:25 jesus loading schema
Note: See TracRevisionLog for help on using the revision log.