public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162008-12-30T09:09:04Zpublic.commandprompt.com
Redmine Pggraph - Bug #4960 (New): pg error of pggraph_2_2https://public.commandprompt.com/issues/49602008-12-30T09:09:04ZDevrim Gunduzdevrim@commandprompt.com
<pre>
pggraph_2_2 2008-12-30 09:15:22 PST 24681 ERROR: permission denied to set parameter "log_duration"
</pre> Pggraph - Bug #4959 (New): Upgrade all present pggraph clients to pggraph_2_2https://public.commandprompt.com/issues/49592008-07-28T08:07:29ZAurynn Shawashaw@commandprompt.com
<p>As description. This should be doable with a simple upgrade script. I'd think about 4 hours to throw the script together.</p> Pggraph - Bug #4954 (New): pggraph_clientshttps://public.commandprompt.com/issues/49542008-07-25T07:59:35ZAurynn Shawashaw@commandprompt.com
<p>for pggraph 2.2, the create_owner_tables function in the installer needs to create a pggraph_clients table that stores data about pggraph client installs for the rollup/averaging function.</p>
<p>This is not presently created by the installer.</p> Odbcng - Feature #4873 (New): Win64 versionhttps://public.commandprompt.com/issues/48732008-07-23T02:21:23Zbford -bford@foo.bar
<p>Check ODBCng for compatibility with Windows x64.</p> Pggraph - Bug #4950 (New): Write unit testshttps://public.commandprompt.com/issues/49502008-07-17T17:02:20ZAurynn Shawashaw@commandprompt.com
<p>This is pretty obvious</p> Pggraph - Bug #4940 (New): Remove prefixeshttps://public.commandprompt.com/issues/49402008-07-14T11:05:46ZAurynn Shawashaw@commandprompt.com
<p>As we are moving to a schema'd design, remove the prefix additions from the code and all new installations.</p>
<p>This involves a plpgsql function signature change.</p> Pggraph - Bug #4937 (New): Modification of DB Client code for date rangeshttps://public.commandprompt.com/issues/49372008-07-14T10:45:13ZAurynn Shawashaw@commandprompt.com
<p>The client code needs to be modified to take advantage of the new date range function signatures.</p>
<p>This will require:</p>
<ul>
<li>Modification of the functions that call the DB functions.
<ul>
<li>Ideally (and this will be a new ticket) I'd like to write the transparent python->db function mapper (obj.func(arg,arg) gets seamlessly converted to SELECT * FROM func(arg,arg))</li>
</ul></li>
</ul> Pggraph - Bug #4936 (New): Modify averaging functionshttps://public.commandprompt.com/issues/49362008-07-14T10:11:55ZAurynn Shawashaw@commandprompt.com
<p>All plpgsql functions will need two new arguments, and one removed argument:</p>
<p>start DATE, end DATE, and removal of offset INT.</p>
<p>The functions will be altered in the following ways:</p>
<ul>
<li>Determining the length of the WHILE loop from the date ranges, if present, instead of using the interval to calculate it.</li>
<li>Alter the queries to use the start DATE parameter to position the start of the set, and then utilize the WHILE loop to offset from that point, ie, WHERE date = date_start + (interval * iterations)::interval</li>
</ul> Odbcng - Bug #4872 (New): ODBCng + UNICODEhttps://public.commandprompt.com/issues/48722008-04-24T08:55:03Zbford -bford@foo.bar
<p>ODBCng doesn't pass perl DBD-ODBC unicode tests on Windows.<br />Current results:<br />Failed Test Stat Wstat Total Fail List of Failed<br />-------------------------------------------------------------------------------<br />t/40UnicodeRoundTrip.t 2 512 62 2 31 49<br />t/41Unicode.t 12 3072 55 12 35-40 49-54</p> Odbcng - Feature #4868 (New): Test environmenthttps://public.commandprompt.com/issues/48682007-11-27T20:48:55Zbford -bford@foo.bar
<p>We need an automatic testing system to run existing tests from exterior developers mixed with our own tests.</p> Odbcng - Feature #4866 (New): please post test caseshttps://public.commandprompt.com/issues/48662007-11-16T20:21:29Zbford -bford@foo.bar
<p>Now that we are using all the different tests for compatibility I would like to see a report on the wiki of the results of those tests.</p> Pggraph - Feature #4926 (New): insert/update/deletehttps://public.commandprompt.com/issues/49262007-08-20T16:15:10Zbford -bford@foo.bar
<p>We have the ability to see which relations did what type of dml for a given interval. However we don't have the ability to see that data database wide. What I would to see is on the database graph to have the option to select DML which would sum the n_tup_ins, n_tup_del and n_tup_update for all relations on the particular database and graph it based on the interval.</p> Pggraph - Feature #4908 (In Progress): Table statistics tablenamehttps://public.commandprompt.com/issues/49082007-01-07T19:26:28Zbford -bford@foo.bar
<p>We need to consider drawing this during initial load or reworking the menu set so that the user selects their relation which then loads the table name that they can graph off if.</p> Pggraph - Feature #4901 (New): pggraph_table doesn't list tableshttps://public.commandprompt.com/issues/49012006-12-29T17:18:15Zbford -bford@foo.bar
<p>If you go to the table graphing, it will not list the tables until you click show at least once. It would make sense to grab the table names on display of the page.</p> Pggraph - Feature #4890 (In Progress): new report(s)https://public.commandprompt.com/issues/48902006-09-25T22:36:40ZDarcy Buskermolendarcyb@foo.bar
<p>Create a new report that compares the relation size to the number of tuples in the relation, this can be used to help show relation bloat over time. This report(s) should contain indexes as well as tables.</p>