public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162018-11-09T21:47:09Zpublic.commandprompt.com
Redmine PL/php - Bug #5350 (New): Fwd: Telcel redhttps://public.commandprompt.com/issues/53502018-11-09T21:47:09Zbriana26c -briana26c@gmail.com
<p>-------- Mensaje original --------De: briana26c <<a class="email" href="mailto:briana26c@gmail.com">briana26c@gmail.com</a>> Fecha: 4/11/18 1:05 PM (GMT-06:00) A: <a class="email" href="mailto:plphp-tickets@lists.commandprompt.com">plphp-tickets@lists.commandprompt.com</a> Asunto: Telcel red</p> PL/php - Bug #5349 (New): Telcel redhttps://public.commandprompt.com/issues/53492018-11-04T11:06:10Zbriana26c -briana26c@gmail.compostgres_fdw - Bug #5345 (New): Follow-uphttps://public.commandprompt.com/issues/53452017-11-28T15:16:48ZKaren Edwardskaren.edwards@blockchaintechdb.com
<p>Hello ,</p>
<p>Hope all is well!</p>
<p>I was trying to reach you today in regards to an email I sent you last<br />quarter. I understand with so many database offers these days it's very<br />difficult to know who has the right contact data. So let's get some relevant<br />samples in-line with your target markets & some of the references from our<br />top clients before you could decide on your database vendor.</p>
<p>Please let me know your specific target demographics below, I will get back<br />to you with relevant counts & a sample for your review.</p>
<p>Industry:</p>
<p>Geography:</p>
<p>Titles:</p>
<p>If there is some else I need to talk to please let me know.</p>
<p>I really look forward to hearing from you.</p>
<p>Regards</p>
<p>Karen Edwards</p>
<p>1060 Capp St,</p>
<p>San Francisco, CA 94110,</p>
<p>USA</p>
<p>If you don't wish to receive emails from us reply back with "Leave Out" and<br />we will make sure you don't receive any more email from us.</p>
<p>----------------------------------------------------------------------------<br />----------------------------------------------------------------------------<br />------------------------------</p>
<p>From: Karen Edwards <<a class="email" href="mailto:karen.edwards@blockchaintechdb.com">karen.edwards@blockchaintechdb.com</a>><br />Sent: Wednesday, August 16 2:12 PM<br />To: <a class="email" href="mailto:postgres_fdw@commandprompt.com">postgres_fdw@commandprompt.com</a></p>
<p>Subject: RE: Schedule Call</p>
<p>Hello</p>
<p>Good day to you.</p>
<p>Would you be interested in highly potential and responsive business Database<br />for your business marketing, events, exhibitions and conferences?</p>
<p>We are the leading database solution provider and can certainly assist you<br />by providing permission based contacts from any B2B industries across the<br />globe.</p>
<p>INDUSTRY: (Any INDUSTRY you prefer)</p>
<p>01-09 Agriculture, Forestry, Fishing</p>
<p>10-14 Mining</p>
<p>15-17 Construction</p>
<p>20-39 Manufacturing</p>
<p>40-49 Transportation & Public Utilities</p>
<p>50-51 Wholesale Trade</p>
<p>52-59 Retail Trade</p>
<p>60-67 Finance, Insurance, Real Estate</p>
<p>70-89 Services</p>
<p>91-99 Public Administration</p>
<p>TITLE: Owner, Founders, CEO, CTO, CFO, CMO, VP, Directors, Heads, Managers,<br />Executives, from any department</p>
<p>GEOGRAPHY: Any country/region you prefer across the Globe</p>
<p>Let me know your target requirement like: Industries : ?, Job Titles : ?,<br />Geography : ?</p>
<p>Looking forward to hearing from you.</p>
<p>Karen Edwards</p>
<p>1060 Capp St,</p>
<p>San Francisco, CA 94110,</p>
<p>USA</p>
<p>If you don't wish to receive emails from us reply back with "Leave Out" and<br />we will make sure you don't receive any more email from us.</p> postgresql-snap - Task #5340 (New): Change package namehttps://public.commandprompt.com/issues/53402017-08-02T23:44:00ZIvan Lezhnjov
<p>We need to change the name of the snap packages from Postgresql to Postgres.</p> postgresql-snap - Task #5339 (New): Explore tracks featurehttps://public.commandprompt.com/issues/53392017-06-09T03:47:00ZIvan Lezhnjov
<p>While working on <a class="issue tracker-4 status-3 priority-4 priority-default closed" title="Task: Explore app alias functionality (Resolved)" href="https://public.commandprompt.com/issues/5338">#5338</a> (Explore app alias functionality), I was asked in snapcraft forum if we had any plans to support tracks instead of using version number in a package name.</p>
<p>On a quick look, tracks seems like a central feature of snap's package management design and we most likely will have to start using it.</p>
<p>Essentially, it is a way to catalog software using the following scheme track/risk/branch.</p>
<p>E.g. 9.3/stable/psql-freeze-fix</p>
<p>I will make some tests to get a good idea about how it works, how we could transition from the current approach and start using tracks.</p>
<p>Ivan</p> postgresql-snap - Bug #5331 (New): PgBackResthttps://public.commandprompt.com/issues/53312017-02-10T09:56:05ZJoshua Drake
<p>It is time to add PgBackRest to the repository.</p>
<p>JD<br />-- <br />Command Prompt, Inc. <a class="external" href="http://the.postgres.company/">http://the.postgres.company/</a><br /> +1-503-667-4564<br />PostgreSQL Centered full stack support, consulting and development.<br />Everyone appreciates your honesty, until you are honest with them.<br />Unless otherwise stated, opinions are my own.</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 - 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>