public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162017-08-02T23:44:00Zpublic.commandprompt.com
Redmine 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> postgres_fdw - Bug #5318 (New): C-Level, VP-Level, Directors and Manager Contactshttps://public.commandprompt.com/issues/53182016-06-08T07:52:53ZTatum LauTatum.Lau@SoftwareDetail.biz
<p>Hi,</p>
<p>Would you be interested in highly responsive B2B Mailing List for your<br />business marketing, events and projects?</p>
<p>We provide contacts from all the industries like Oil and Gas, Payroll,<br />Technology, Healthcare, Hospitality, Telecom, e-commerce and many more.</p>
<p>We can provide you with titles like:</p>
<p>CIO, CEO, CFO, CTO and COO</p>
<p>IT Directors, VP of IT and IT Managers</p>
<p>VP of Finance, Director of Finance and Finance Manager</p>
<p>HR Manager, HR Director and VP of HR</p>
<p>Marketing Manager, Marketing Director and VP of Marketing</p>
<p>Sales Manager, Director of Sales and VP of Sales</p>
<p>And many more from job functions and industries.</p>
<p>Let me know the titles and industry you are looking for your campaign so I<br />can provide you with further information for the same.</p>
<p>Await your response!</p>
<p>Regards,</p>
<p>Tatum Lau</p>
<p>Information Analyst </p>
<pre><code>To Opt Out, please respond "Leave Out" in<br />the Subject line.</code></pre> pitrtools - Feature #5315 (New): cmd_standby: Data Directory vs. Configuration Directory?https://public.commandprompt.com/issues/53152015-05-14T15:57:15ZMichael Vitalemichael@commandprompt.com
<p>Normally on most distros except Ubuntu, you can run pg_ctl command to start, stop, init the cluster, etc. On Ubuntu, (it is much more elaborate, to my liking I must say), where pg_ctl is enclosed within the wrapper, pg_ctlcluster. Not only that, but there is a separation between the data directory and the configuration directory:<br />configuration directory: /etc/postgresql/<version>/main<br />data directory : /var/lib/postgresql/<version>/main</p>
<p>Now to the point and how it relates to PITR TOOLS. By default, PITR TOOLs uses pg_ctl. It offers the option to either copy your configuration files specified in cmd_standby.conf to the data directory, or just start pg_ctl with the confs specified on the command line:</p>
<p>no_copy_conf: true --> command line specification of confs<br />no_copy_conf: false--> confs are copied to data directory</p>
<p>It would be nice if we had another parameter defined right under pgdata in cmd_standby.ini:<br />pgdata: /var/lib/postgresql/9.3/main</p>
<p>-- new proposed attribute<br />pgconf: /etc/postgresql/9.3/main</p>
<p>one implementation solution of many:<br />The cmd_standby executable could be modified slightly so that whenever pg_ctl is invoked and if no_copy_conf is false, and pgconf is not empty, then copy the specified conf files to the pgconf directory instead of the default action: copying them to the data directory. Furthermore, when pg_ctl is invoked in these cases pass to it as the -D parameter, the conf directory, not the data directory.</p> postgres_fdw - Bug #5312 (New): AutoDesk Usershttps://public.commandprompt.com/issues/53122015-03-09T07:36:41ZKina Lawrencekina.lawrence@verifiedtechlist.com
<p>Hi,</p>
<p>Would you be interested in AutoDesk Users contact information in excel sheet<br />for unlimited marketing usage? We provide Top Decision Makers information<br />like Name, Email, Title, Phone and company details of companies using<br />AutoDesk.</p>
<p>AutoCAD</p>
<p>Solid Works</p>
<p>Adobe</p>
<p>Bentley</p>
<p>Cinema4D</p>
<p>EDS Corporation</p>
<p>Parsons Brinckerhoff</p>
<p>And many more...</p>
<p>Please let me know your thoughts so that I can send you cost of the list.</p>
<p>Appreciate your time and look forward to hear from you.</p>
<p>Regards,</p>
<p>Kina</p>
<p>AutoDesk Consultant</p>
<p>If you are not the right person, feel free to forward this email to the<br />right person in your organization.</p>
<table>
<tr>
<td> List acquisition </td>
<td> Technology Lists </td>
<td> Email/Data Appending </td>
<td> Search Engine<br />Optimization </td>
</tr>
</table>
<p>If you don't want to include yourself in our mailing list, please reply back<br />"Leave Out" in a subject line</p> pitrtools - Feature #5265 (New): Avoid the need to manually edit postgresql.conf fileshttps://public.commandprompt.com/issues/52652012-09-17T04:13:45ZAlexey Klyukinalexk@commandprompt.com
<p>Right now, we have a bizarre combination of running cmd_archiver from the command line and plugging it in postgresql.conf manually. Given that we already know the location of postgresql.conf, we can edit it to set all necessary options (wal_level, max_wal_senders, archive_mode, archive_command) automatically, leaving only database restart as a task that should be performed manually.</p> PL/php - Feature #5259 (New): Add support for anonymous DO blocks.https://public.commandprompt.com/issues/52592011-05-27T05:52:31ZAlexey Klyukinalexk@commandprompt.com
<p>PostgreSQL 9.0 introduced a notion of inline DO blocks:<br /><a class="external" href="http://www.postgresql.org/docs/9.0/interactive/sql-do.html">http://www.postgresql.org/docs/9.0/interactive/sql-do.html</a></p>
<p>So far, nothing stops us from adding support for such blocks written in PL/PHP.</p> PL/php - Discussion #5256 (New): Creating a PL/php distributionhttps://public.commandprompt.com/issues/52562011-05-21T18:36:16ZJoshua Drake
<p>Since we need PHP source to create plphp (due to no one shipping as embed), perhaps we should just include the source as part of the download of php and have a predefined configure that deals with all of it for people. Thoughts?</p> Simpycity - Bug #5000 (New): Automatic Rollback Fix.https://public.commandprompt.com/issues/50002009-04-29T11:22:37ZLacey Powerslacey.powers@commandprompt.com
<p>Simpycity doesn't always issue a rollback for some transactions, such as failed functions.</p>
<p>This should be fixed, and an appropriate test case created to verify the fix and test in future releases.</p> Pggraph - Bug #4956 (New): dbrollup.py needs to support pggraph 2.2https://public.commandprompt.com/issues/49562008-07-25T08:02:24ZAurynn Shawashaw@commandprompt.com
<p>Per <a class="issue tracker-1 status-5 priority-5 priority-high3 closed" title="Bug: 1-hour bug broken on v2.2 installs (Closed)" href="https://public.commandprompt.com/issues/4953">#4953</a> and the 1-hour bug, dbrollup.py needs to be updated for pggraph 2.2 to support the new table, table structure, and different location of the pggraph_clients data.</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 #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 #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> 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>