public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162016-12-09T07:11:35Zpublic.commandprompt.com
Redmine postgresql-snap - Feature #5327 (In Progress): New snap packages to be createdhttps://public.commandprompt.com/issues/53272016-12-09T07:11:35ZJoshua Drake
<p>pgbouncer<br />pgpool</p> pitrtools - Feature #5306 (Feedback): Reimplementation of queuehttps://public.commandprompt.com/issues/53062014-05-13T12:58:27ZJoshua A. Drakezam@commandprompt.com
<p>Reimplementation of PITRTools queue<br />The current queue system possesses the following limitations:<br />1. No job control - If we are generating xlogs faster than we can ship them, rsync processes will be spawned uncontrollably.<br />2. A continuous stream of transaction logs must be generated for correct operation of the archiver. If there are no new logs <br />coming in, logs still in the queues will not get shipped.</p>
<p>Suggested solution:<br /><pre>
Queue management daemon - Have cmd_archiver only queue logs, with a separate daemon shipping them.
* cmd_queue daemon
- write PID to a file
- In worker thread
] Ship logs in queue with subprocess calls when self to-do list is not empty
} If successful, remove paths from self to-do list and log appropriate output
} Else, log which queues failed
] Wait a few seconds [configurable]
] Repeat
- In main thread
] Wait for data [absolute paths to queued logs] on a pipe or UNIX socket
] On data, parse and extract paths, append paths to self to-do list
] Repeat
* When cmd_archiver is called with a new archive, copy the archive to slave queues and write paths to cmd_queue via pipe/socket
</pre></p> 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> 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> 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 #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>