root/sql


Mode:

Legend:

Added
Modified
Copied or renamed
Rev Chgset Date Author Log Message
(edit) @6b9f38ffb400becb8ab312d34abd2981bca9fe87 [6b9f38ffb400becb8ab312d34abd2981bca9fe87] 06/16/08 19:16:10 Denish Patel <denish@omniti.com> remove min/max values from rollup tables/functions.
(edit) @601c99b9ea251da8e30fe85e055c372a540491ee [601c99b9ea251da8e30fe85e055c372a540491ee] 06/06/08 20:42:16 Denish Patel <denish@omniti.com> Exception handling UNIQUE_VIOLATION in log_whence_change_log function.
(edit) @d95460a5334988d9e1dc8c94c3eefbaf222c2d48 [d95460a5334988d9e1dc8c94c3eefbaf222c2d48] 06/06/08 17:57:15 Denish Patel <denish@omniti.com> exception handing on stratcon.loading_dock_metric_numeric_s_whence_log
(edit) @23df8e9f199cb077a586490d9d495708b62bd93e [23df8e9f199cb077a586490d9d495708b62bd93e] 06/01/08 02:38:47 Theo Schlossnagle <jesus@omniti.com> fix PK
(edit) @6390014a64eb9ab5483bc88e66779b6c0ef7a20d [6390014a64eb9ab5483bc88e66779b6c0ef7a20d] 05/30/08 20:42:07 Denish Patel <denish@omniti.com> Added DDL dump for reconnointer database
(edit) @99564b3a9f761d3fb72e07eaa38809b4ff64c558 [99564b3a9f761d3fb72e07eaa38809b4ff64c558] 05/30/08 20:33:26 Denish Patel <denish@omniti.com> Updated Text change log trigger function to log older data changes too.
(edit) @6ea1dad6f00d20ef52591c282ffc9b1e002d5420 [6ea1dad6f00d20ef52591c282ffc9b1e002d5420] 05/24/08 00:33:16 Theo Schlossnagle <jesus@omniti.com> Oops.. This caused every line in loading_dock_status_s to be considered as …
(edit) @197579c398b7365b2eea60f9b2245fdf72ada185 [197579c398b7365b2eea60f9b2245fdf72ada185] 05/22/08 21:11:14 Denish Patel <denish@omniti.com> Grants.
(edit) @809b898d87dcc7153a3360ebb67c91113854f9a7 [809b898d87dcc7153a3360ebb67c91113854f9a7] 05/22/08 21:08:22 Denish Patel <denish@omniti.com> Added Remove_mtric function;
(edit) @3b875de14155ab34c26bdae600fc2827218f85f2 [3b875de14155ab34c26bdae600fc2827218f85f2] 05/21/08 20:41:30 Denish Patel <denish@omniti.com> better handling NOTICE for running job.
(edit) @a2c8a40a569ad8bc6677c21303849d5844ce5436 [a2c8a40a569ad8bc6677c21303849d5844ce5436] 05/21/08 20:25:37 Denish Patel <denish@omniti.com> Updated roll ups functions to process all available records from …
(edit) @b927b3bbf9eeab57dc26e56d2eddfea8cc199a49 [b927b3bbf9eeab57dc26e56d2eddfea8cc199a49] 05/14/08 20:34:00 Denish Patel <denish@omniti.com> updated sequence ddl to start with 1.
(edit) @a7da22e2c7fcc5e15bb1a4e4ab695d6a0c560b43 [a7da22e2c7fcc5e15bb1a4e4ab695d6a0c560b43] 05/14/08 20:10:38 Denish Patel <denish@omniti.com> Added date_trunc('hour',rollup_time) index on 20m rollup tables so we can …
(edit) @be8707fb024addfa6eb855a9d160e6f2b5afec3f [be8707fb024addfa6eb855a9d160e6f2b5afec3f] 05/14/08 18:45:06 Denish Patel <denish@omniti.com> Replace TIMESTAMP with TIMESTAMPTZ.
(edit) @152d473243c4c0e838439fd654a698515e8288fc [152d473243c4c0e838439fd654a698515e8288fc] 05/14/08 15:31:43 Denish Patel <denish@omniti.com> stddev_value removed.
(edit) @5de3ee066898c7932e978dbe8224ca4e280635cb [5de3ee066898c7932e978dbe8224ca4e280635cb] 05/14/08 00:54:13 Theo Schlossnagle <jesus@omniti.com> fix the triggers.. the row itself is called nam, the summary is …
(edit) @143a7f5401614fa0dcc032e7a584d559ac74def5 [143a7f5401614fa0dcc032e7a584d559ac74def5] 05/13/08 21:53:09 Denish Patel <denish@omniti.com> updated 6 hours and 12 hours roll up functions and modify column name for …
(edit) @c1fcb76822fc1aa6b47a9999834cab6c2abeba47 [c1fcb76822fc1aa6b47a9999834cab6c2abeba47] 05/12/08 16:10:25 Denish Patel <denish@omniti.com> Added metric_name_summary table and updated functions to insert rows to …
(edit) @87e2e42dc13b0cfe0cfafcbc70430174c89a04a1 [87e2e42dc13b0cfe0cfafcbc70430174c89a04a1] 05/12/08 15:05:32 Denish Patel <denish@omniti.com> fixed 20m rollup function and table.
(edit) @69db8eb9c49a9d2c4427e7001aa0baa803248de8 [69db8eb9c49a9d2c4427e7001aa0baa803248de8] 05/09/08 21:25:50 Denish Patel <denish@omniti.com> Created trigger on stratcon.loading_dock_status_s to log the entry if …
(edit) @9c824156bbb942b0da737b077c77025f0b56c67d [9c824156bbb942b0da737b077c77025f0b56c67d] 05/09/08 20:53:07 Denish Patel <denish@omniti.com> fix 20 minutes rollup function.
(edit) @3b5d1e9688429ed8e55ebcc0a750dda9a2fe54b4 [3b5d1e9688429ed8e55ebcc0a750dda9a2fe54b4] 05/09/08 20:39:46 Denish Patel <denish@omniti.com> Updated whence column to timestamp instead of timestaptz. updated …
(edit) @7e71217def419c242b081547a970d47a5bf3f20d [7e71217def419c242b081547a970d47a5bf3f20d] 05/09/08 18:03:15 Theo Schlossnagle <jesus@omniti.com> windowed retrieval functions
(edit) @d67a38b6a56900457dc690b2dd62cbd081dca6aa [d67a38b6a56900457dc690b2dd62cbd081dca6aa] 04/16/08 21:05:40 Denish Patel <denish@omniti.com> modified rollup_time6/12 colums to rollup_time and changed functions …
(edit) @8894bdadccd8a4c542f45deafdd40965f568cd81 [8894bdadccd8a4c542f45deafdd40965f568cd81] 04/02/08 19:28:43 Denish Patel <denish@omniti.com> updated functions for rollups
(edit) @ee0d0b765f3a51e1790b26901b54a3c6ac408722 [ee0d0b765f3a51e1790b26901b54a3c6ac408722] 03/28/08 19:38:56 Denish Patel <denish@omniti.com> Final 5 minutes and 1 hour rollup functions
(edit) @5eaa1785247692fe06e4dffe28ec8abdf751865a [5eaa1785247692fe06e4dffe28ec8abdf751865a] 03/28/08 19:12:13 Denish Patel <denish@omniti.com> Final 5 minutes and 1 hour rollup functions
(edit) @3a1a63f5dd675d5b58def4ed6e2727db597f31b5 [3a1a63f5dd675d5b58def4ed6e2727db597f31b5] 03/27/08 20:51:08 Denish Patel <denish@omniti.com> updated functions and removed odd for rollups
(edit) @0dbb5eb9b2c9f102370e5d34d527dde28d3588d4 [0dbb5eb9b2c9f102370e5d34d527dde28d3588d4] 03/27/08 20:05:16 Denish Patel <denish@omniti.com> updated functions for rollups
(edit) @03c905446907610b20f89a64a0d2810d134e52ec [03c905446907610b20f89a64a0d2810d134e52ec] 03/26/08 22:02:44 Denish Patel <denish@omniti.com> updated functions for rollups
(edit) @b9b5a612dc45fbaf19be9da90d69d61dc0491e1e [b9b5a612dc45fbaf19be9da90d69d61dc0491e1e] 03/21/08 19:56:26 Denish Patel <denish@omniti.com> Updated Schema Sql
(edit) @7de429d08625671e3471252391c6ef0bc9c5cf82 [7de429d08625671e3471252391c6ef0bc9c5cf82] 03/06/08 04:55:25 Theo Schlossnagle <jesus@omniti.com> loading schema
Note: See TracRevisionLog for help on using the revision log.