public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162010-06-29T05:25:59Zpublic.commandprompt.com
Redmine PL/php - Bug #5225 (New): Unable to build PL/php on OS X (PHP 5.3)https://public.commandprompt.com/issues/52252010-06-29T05:25:59ZAlexey Klyukinalexk@commandprompt.com
<p>On OS X embed is built as a bundle instead of a library, making it impossible to link against it.</p>
<p>I've submitted the problem to the PHP project:<br /><a class="external" href="http://bugs.php.net/bug.php?id=48318">http://bugs.php.net/bug.php?id=48318</a></p>
<p>Still, it's not possible to build PL/php at the moment on this platform.</p> Pggraph - Bug #4943 (New): Future Planning and Ideashttps://public.commandprompt.com/issues/49432008-07-14T11:32:17ZAurynn Shawashaw@commandprompt.com
<ul>
<li>Javascript+SVG-based graphs, based on example code Darcy showed off a while back. This would allow us to do offset-based graphs (clicking an offset of, say, 5 days scrolls it back in time that far), as well as the ability to do click & drag ala the Google Maps interface.</li>
</ul> Pggraph - Feature #4933 (New): Feature requests, pggraphhttps://public.commandprompt.com/issues/49332008-03-12T12:44:15ZAurynn Shawashaw@commandprompt.com
<p>From cashnet:</p>
<pre>
Should at least display timezone on graphs (would be better if this was configurable).
Unused indexes is too strict, assuming that it's just looking for 0 idxscans (since it's not showing that, I don't know... :) ). It should show index usage stats, and also include indexes that have low usage, perhaps compared to other indexes on the table, or to table stats.
It'd also be good to have a report of tables that could use indexes. I'll typically use a metric like tablescans * relpages, with a cap of say 100 or 200. If this was done with stats over time the metric would essentially be "here's tables that we're doing more than X sequential pages per $unit_time".
</pre> Pggraph - Feature #4932 (New): Have pggraph directly access Wiki passwordshttps://public.commandprompt.com/issues/49322007-12-31T10:28:34ZAurynn Shawashaw@commandprompt.com
<p>Should we have pggraph be on its own, independent password auth, or link it directly to the wiki pw auth?</p> Pggraph - Feature #4931 (New): Develop a nagios plugin for pggraph checkshttps://public.commandprompt.com/issues/49312007-12-18T19:24:29ZDevrim Gunduzdevrim@commandprompt.com
<p>Develop a nagios plugin for pggraph checks</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 #4925 (New): Allow graphing specific intervalshttps://public.commandprompt.com/issues/49252007-07-03T08:28:32ZDarcy Buskermolendarcyb@foo.bar
<p>Add the ability to graph a specific block of time.</p>
<p>IE I'd like to see the 10 minute graph from 2 weeks ago, so that I can inspect Foo. and corilate it with information provided by a customer.</p> Pggraph - Feature #4915 (In Progress): insert_time should be timestamptzhttps://public.commandprompt.com/issues/49152007-03-21T06:35:32ZDarcy Buskermolendarcyb@foo.bar
<p>We should be providing all date logging with timestamps, so that it's easier to work in our clients respective timezones</p> Pggraph - Feature #4914 (In Progress): customer feedbackhttps://public.commandprompt.com/issues/49142007-03-19T20:54:29Zbford -bford@foo.bar
<p>(08:53:42 PM) linuxpoet: oh you mean like a custom repot?<br />(08:53:51 PM) Crad: Something like <a class="external" href="http://server12.uac.ehpg.net/rtg/view.php?rid=1">http://server12.uac.ehpg.net/rtg/view.php?rid=1</a> would be awesome<br />(08:54:00 PM) Crad: even if I had to pick the tables to show.<br />(08:54:34 PM) linuxpoet: yeah we could probably do something like that<br />(08:54:41 PM) linuxpoet: let me make a ticket so we don't loose it</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 #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> PL/php - Feature #4984 (In Progress): Composite Type Argument as tablehttps://public.commandprompt.com/issues/49842005-12-15T03:38:44Zbford -bford@foo.bar
<p>creating composite type argument named table:</p>
<pre> CREATE TABLE employee (name text, basesalary integer, bonus integer); </pre>
<pre> CREATE TABLE employee_ext (name text, basesalary integer, bonus integer, other text); </pre><br /><pre>
CREATE FUNCTION empcomp(table) RETURNS integer AS $$
return $argsr0['basesalary'] + $argsr0['bonus'];
$$ LANGUAGE 'plphp';
</pre><br />SELECT name, empcomp(table) FROM employee;<br />SELECT name, empcomp(table) FROM employee_ext;
<p>eg. type table is table taken from FROM (so once time will be employee, second time employee_ext)<br />now i must have x functions to do same thing with different argument</p> PL/php - Feature #4979 (In Progress): Add support for IN/OUT parametershttps://public.commandprompt.com/issues/49792005-12-05T07:37:14ZÁlvaro Herreraalvherre@commandprompt.com
<p>Add support for OUT parameters so that the user can skip specifying a return type explicitely.</p> PL/php - Bug #4972 (In Progress): array PHP <-> Pg conversion is brokenhttps://public.commandprompt.com/issues/49722005-11-23T11:48:44ZÁlvaro Herreraalvherre@commandprompt.com
<p>Element parsing in arrays can easily be confused. Test case:</p>
<pre>
create or replace function another_text_test(text[], int)
returns text language plphp as $$ return $argsr0[$argsr1]; $$;
</pre>
<p>Strings should be quoted before passing them to PHP, so the NOTICE from PHP here is bogus:</p>
<pre>
pl_regression=# select another_text_test($${"foo",'bar', "{"}$$, 0);
NOTICE: plphp: Use of undefined constant foo - assumed 'foo'
another_text_test
-------------------
foo
(1 fila)
</pre>
<p>The same reason causes this to "eat" the inner level of quotes:</p>
<pre>
pl_regression=# select another_text_test($${"'bar'", "{"}$$, 0);
another_text_test
-------------------
bar
(1 fila)
</pre>
<p>Note particularly this totally unexpected behavior:</p>
<pre>
pl_regression=# select another_text_test($${"'bar'", "{"}$$, 1);
another_text_test
-------------------
array(
(1 fila)
</pre> PL/php - Feature #4967 (In Progress): Redesign memory handlinghttps://public.commandprompt.com/issues/49672005-11-16T17:31:06ZÁlvaro Herreraalvherre@commandprompt.com
<p>Currently memory is not handled very well. It would be nice if we had one MemoryContext for each function that could be automatically reset or deleted when the function is recompiled. Additionally we would need a compilation context, and maybe an execution context as well.</p>