root/sql


Mode:

Legend:

Added
Modified
Copied or renamed
Rev Chgset Date Author Log Message
(edit) @161a5c5dbc37986a5d1c5ce66869d4504f97f0eb [161a5c5dbc37986a5d1c5ce66869d4504f97f0eb] 10/01/09 18:24:01 Denish Patel <denish@omniti.com> Change schema to stratcon and modified functions to be secturity definer
(edit) @b57ec8315f866c742be1da0a080ee0c836ff02a1 [b57ec8315f866c742be1da0a080ee0c836ff02a1] 10/01/09 18:10:47 Denish Patel <denish@omniti.com> noit functions related to fetch data
(edit) @003566b519017539659f61ab68d038cb3218e43b [003566b519017539659f61ab68d038cb3218e43b] 10/01/09 18:08:18 Robert Treat <robert@omniti.com> give me a uuid and it's noit, i'll give you a sid and which node to put it …
(edit) @3b8a086327fecf81c67436b95e046185bd2dad97 [3b8a086327fecf81c67436b95e046185bd2dad97] 09/30/09 17:14:36 Robert Treat <robert@omniti.com> what are we up to?
(edit) @30ba483a94e1eaee4fc0b743d7126f60ffb8a908 [30ba483a94e1eaee4fc0b743d7126f60ffb8a908] 09/30/09 17:08:09 Robert Treat <robert@omniti.com> straggling file rename
(edit) @420b34c7d61262546669125ae17b29becad77298 [420b34c7d61262546669125ae17b29becad77298] 09/30/09 17:07:46 Robert Treat <robert@omniti.com> actually, this should be in noit schema, though we do want to leave it …
(edit) @81f7001e39e1c3484d225b7a609fc803c86ba5ef [81f7001e39e1c3484d225b7a609fc803c86ba5ef] 09/30/09 17:04:25 Robert Treat <robert@omniti.com> new task locking infrastructure
(edit) @64c35d610d430e39870bc67c35bdf49298ba29f8 [64c35d610d430e39870bc67c35bdf49298ba29f8] 09/30/09 16:52:30 Robert Treat <robert@omniti.com> file renames
(edit) @e0b4c4bf93b3aea304cd8cf9e9f7a02f9cc79a88 [e0b4c4bf93b3aea304cd8cf9e9f7a02f9cc79a88] 09/30/09 16:52:12 Robert Treat <robert@omniti.com> queue for tracking which numeric intervals need to be rolled up
(edit) @392462ca87d64f403a0ac61c95102e6611b362f3 [392462ca87d64f403a0ac61c95102e6611b362f3] 09/30/09 16:44:33 Robert Treat <robert@omniti.com> status type check table
(edit) @5745519bbdae8e0191e208603505894084660654 [5745519bbdae8e0191e208603505894084660654] 09/30/09 16:41:15 Robert Treat <robert@omniti.com> numeric metrics
(edit) @77e875df87c94f8cd2b8fbc32fbe360623e759b8 [77e875df87c94f8cd2b8fbc32fbe360623e759b8] 09/30/09 16:14:10 Robert Treat <robert@omniti.com> adding schema for rollup tables, with array based storage
(edit) @88d5aaab122fefd6471e1d4604f54cd1a6df433b [88d5aaab122fefd6471e1d4604f54cd1a6df433b] 09/29/09 22:22:18 Robert Treat <robert@omniti.com> text metric tables
(edit) @3e3863d0f5b6548f78558042bd6c87f71145a732 [3e3863d0f5b6548f78558042bd6c87f71145a732] 09/29/09 21:53:51 Robert Treat <robert@omniti.com> metric name summary
(edit) @3278b4e18773a14f0cf214226356adbc065fa9be [3278b4e18773a14f0cf214226356adbc065fa9be] 09/29/09 21:43:28 Robert Treat <robert@omniti.com> tag tables
(edit) @378ef447b1015a081fe182f16097392fa036a9ce [378ef447b1015a081fe182f16097392fa036a9ce] 09/29/09 20:59:27 Robert Treat <robert@omniti.com> check status tables
(edit) @ff905e92ad93d8c9a71dcfc0d1825f3667a22c01 [ff905e92ad93d8c9a71dcfc0d1825f3667a22c01] 09/29/09 20:53:19 Robert Treat <robert@omniti.com> fix whoopsies
(edit) @35417f1d20ade67bfbf99b03c861fe1756ee11cd [35417f1d20ade67bfbf99b03c861fe1756ee11cd] 09/29/09 20:48:20 Robert Treat <robert@omniti.com> layout of primary check tables
(edit) @4e7af0052829e39e8da8375b559e9be499b247c2 [4e7af0052829e39e8da8375b559e9be499b247c2] 09/29/09 20:22:36 Robert Treat <robert@omniti.com> store data in chunks as array values to save storage space
(edit) @a34bc1266a0a4f7fa69f17c5957f160162a4398d [a34bc1266a0a4f7fa69f17c5957f160162a4398d] 09/29/09 20:12:34 Robert Treat <robert@omniti.com> map table plus placeholders for upcoming schema
(edit) @06519e0d896bfca30746212670c342a1b84a74a5 [06519e0d896bfca30746212670c342a1b84a74a5] 07/10/09 00:26:52 Theo Schlossnagle <jesus@omniti.com> Patch from Dan. fixes #153
(edit) @f6540baac0ed25babb2a91d9b715988abb653bcb [f6540baac0ed25babb2a91d9b715988abb653bcb] 06/15/09 23:07:39 Theo Schlossnagle <jesus@omniti.com> flag-day(stratcond,database) partition the loading docks, refs #140
(edit) @9d38c6543b77583aaef091ecd0e2903e89067d0b [9d38c6543b77583aaef091ecd0e2903e89067d0b] 06/10/09 17:39:06 Denish Patel <denish@omniti.com> updated schema ddl
(edit) @6adb5a7837cf0e5945ed038897c9b08c7259701c [6adb5a7837cf0e5945ed038897c9b08c7259701c] 05/20/09 23:49:08 Theo Schlossnagle <jesus@omniti.com> update the schema, remove unnecessary crap
(edit) @a647406d9e447fa4cb7212f74bc63a1fcf52dfea [a647406d9e447fa4cb7212f74bc63a1fcf52dfea] 04/09/09 20:55:04 Denish Patel <denish@omniti.com> updated pgdump ddl
(edit) @17a8e8e4556d3b18451fd9531ef964be402a98d0 [17a8e8e4556d3b18451fd9531ef964be402a98d0] 03/28/09 02:14:16 Theo Schlossnagle <jesus@omniti.com> make the counter_dev stuff much more intelligent and accommodating of …
(edit) @c3a1f2e12de43c398369bb5a3f902eebde93f9bb [c3a1f2e12de43c398369bb5a3f902eebde93f9bb] 03/26/09 21:58:11 Denish Patel <denish@omniti.com> checking in postgres ddl dump
(edit) @e3e35fcfbb73d6001f7b6dca7ff7311e1148ccfb [e3e35fcfbb73d6001f7b6dca7ff7311e1148ccfb] 03/21/09 02:07:35 Robert Treat <robert@omniti.com> use gin index for tsvectors
(edit) @9295ab0de02cda482cfd2a5762f8a76727b480d1 [9295ab0de02cda482cfd2a5762f8a76727b480d1] 12/03/08 21:32:30 Denish Patel <denish@omniti.com> pg ddl update
(edit) @ea0809f5e7f454f5e874bca7d79be8e2d6a10789 [ea0809f5e7f454f5e874bca7d79be8e2d6a10789] 12/03/08 17:37:57 Denish Patel <denish@omniti.com> Added job to cleanup prism.saved_graphs table with saved_graphs=false.
(edit) @f67c8f851568c1e75293edbe51cd405f940bab8b [f67c8f851568c1e75293edbe51cd405f940bab8b] 11/20/08 23:03:02 Denish Patel <denish@omniti.com> updated saved_graphs before i/u trigger function
(edit) @d4547fc2ca717194bd02bda7276a0efa26d120d0 [d4547fc2ca717194bd02bda7276a0efa26d120d0] 11/04/08 20:23:11 Denish Patel <denish@omniti.com> prism.saved_graphs triggers adjustments
(edit) @be06d4c772959d7f67b61729ed0fcfa446eb59a4 [be06d4c772959d7f67b61729ed0fcfa446eb59a4] 10/16/08 16:17:38 Denish Patel <denish@omniti.com> fixed ownership of tables
(edit) @c256764571a55858b9a8db0f8905c297ec481926 [c256764571a55858b9a8db0f8905c297ec481926] 10/14/08 19:00:42 Denish Patel <denish@omniti.com> updated remove_metric function
(edit) @9e9c974e402a479ebbc927ca69c82166708b2d80 [9e9c974e402a479ebbc927ca69c82166708b2d80] 10/13/08 21:12:29 Denish Patel <denish@omniti.com> another fix for saved graph serach
(edit) @04c2ba0f9a1814ea044e5060104e73817640055d [04c2ba0f9a1814ea044e5060104e73817640055d] 10/13/08 18:13:40 Denish Patel <denish@omniti.com> Fixed sved graphs trigger
(edit) @848c999201996fa821ee897f8bc9e3c0979a575f [848c999201996fa821ee897f8bc9e3c0979a575f] 10/07/08 14:29:57 Denish Patel <denish@omniti.com> pg ddl export
(edit) @fb7be7b187d801c131a11404d2c489a6fc8350a6 [fb7be7b187d801c131a11404d2c489a6fc8350a6] 09/26/08 21:14:54 Denish Patel <denish@omniti.com> Modified function and trigger for saved_graphs as it was messing up with …
(edit) @c73b2b53bb74c7e8135888bc652903c9327f7dbd [c73b2b53bb74c7e8135888bc652903c9327f7dbd] 09/25/08 19:24:59 Denish Patel <denish@omniti.com> granted more privs to stratcon user
(edit) @15df64bd213a7a14a521d3d2d4418ee9379272aa [15df64bd213a7a14a521d3d2d4418ee9379272aa] 09/25/08 16:07:48 Denish Patel <denish@omniti.com> implemented add/remove tags functionality for graphs and created function …
(edit) @43ec19ac079e004379a4c8d8117756c8d622eff8 [43ec19ac079e004379a4c8d8117756c8d622eff8] 09/25/08 01:18:36 Denish Patel <denish@omniti.com> added index
(edit) @75075e2a62f4974e24117f519581ad75b2a083c4 [75075e2a62f4974e24117f519581ad75b2a083c4] 09/24/08 20:45:15 Denish Patel <denish@omniti.com> Moved metric_tags from prism schema to stratcon and grant all table to …
(edit) @f3544432ddf95a1f7eabd18d8fa0f355191362eb [f3544432ddf95a1f7eabd18d8fa0f355191362eb] 09/24/08 19:50:24 Denish Patel <denish@omniti.com> Added search and tags functionalities
(edit) @146a7f3bfbf2f113f1cbdba31a2ba3e575d3e2f8 [146a7f3bfbf2f113f1cbdba31a2ba3e575d3e2f8] 09/22/08 18:09:27 Denish Patel <denish@omniti.com> Full database dump
(edit) @9f9d948f5f91f25c6ec5d43a5ddcd1143e30fd45 [9f9d948f5f91f25c6ec5d43a5ddcd1143e30fd45] 09/22/08 18:00:45 Denish Patel <denish@omniti.com> pg ddl update-- alter schema statrcon owner to reconnoiter
(edit) @70d8a8f096162b8f5ef06f5668066b9e7e942814 [70d8a8f096162b8f5ef06f5668066b9e7e942814] 09/22/08 17:57:16 Denish Patel <denish@omniti.com> pg ddl update
(edit) @0a06b2cbef3380c0fa794480d2fae8b4b1431f92 [0a06b2cbef3380c0fa794480d2fae8b4b1431f92] 08/26/08 01:25:15 Theo Schlossnagle <jesus@omniti.com> refs #50
(edit) @60d776d5d65d4ceec7b23dbddb1d8e3893c97571 [60d776d5d65d4ceec7b23dbddb1d8e3893c97571] 08/26/08 00:24:40 Theo Schlossnagle <jesus@omniti.com> just use reconnoiter_ddl_dump.sql as the master
(edit) @8c44e3b0e275f77a5f98f49c8b0ae180976694e9 [8c44e3b0e275f77a5f98f49c8b0ae180976694e9] 08/11/08 20:58:43 Denish Patel <denish@omniti.com> dump stratcon schema
(edit) @3be398539c4bcd0e77acf4390c6dda1635329b58 [3be398539c4bcd0e77acf4390c6dda1635329b58] 08/03/08 19:23:21 Theo Schlossnagle <jesus@omniti.com> people are gonna need this crontab to see rollups
(edit) @356779758e509ee0f1a2f419e9fab1d48fdc3c33 [356779758e509ee0f1a2f419e9fab1d48fdc3c33] 07/12/08 15:13:51 Theo Schlossnagle <jesus@omniti.com> implement a materialized view on the most recent metric_text change (need …
(edit) @4aae95d137f38b64f49d27c9611b1fba6242666a [4aae95d137f38b64f49d27c9611b1fba6242666a] 07/11/08 19:40:02 Denish Patel <denish@omniti.com> updated Reconniter DDL dump
(edit) @47b88b010a032a620acac2e7dff46570fe80d64a [47b88b010a032a620acac2e7dff46570fe80d64a] 07/11/08 19:35:19 Denish Patel <denish@omniti.com> corrected error warning for stratcon.mv_loading_dock_check_s()
(edit) @e94863c5d22e2229730530ce3039661489cbbd73 [e94863c5d22e2229730530ce3039661489cbbd73] 07/10/08 18:34:28 Theo Schlossnagle <jesus@omniti.com> make the fetch_ procedures also accept sids
(edit) @adba02c5fdb37a1095d0d170a8cf31937dbedbb0 [adba02c5fdb37a1095d0d170a8cf31937dbedbb0] 07/10/08 16:49:20 Denish Patel <denish@omniti.com> added mv_loading_dock_check_s() trigger function and related …
(edit) @ee3bbe783b5e3fcbb1febb6a523e12550d04d90d [ee3bbe783b5e3fcbb1febb6a523e12550d04d90d] 07/10/08 02:51:36 Theo Schlossnagle <jesus@omniti.com> fix bug in update config and revert the out-of-order text metric support …
(edit) @5366a70920df98ecf37fed906dfe718d250c4ec1 [5366a70920df98ecf37fed906dfe718d250c4ec1] 07/02/08 18:29:43 Denish Patel <denish@omniti.com> Exported Latest DDL dump
(edit) @e0795d09a594dd276dd59643a85230388401fb06 [e0795d09a594dd276dd59643a85230388401fb06] 07/01/08 14:14:22 Theo Schlossnagle <jesus@omniti.com> fix up insert function for config info, refs #26
(edit) @7710784460d9831062155d3e99f3bf22e4d978b0 [7710784460d9831062155d3e99f3bf22e4d978b0] 06/30/08 19:32:15 Denish Patel <denish@omniti.com> added node configuration tables and trigger.
(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.