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.compostgresql-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 - Bug #5328 (New): threaded_rsync.py: --delete-excluded causes all files to be deletedhttps://public.commandprompt.com/issues/53282017-01-17T10:48:15ZEric Worden
<p>If rsync option "--delete-excluded" is passed to threaded_rsync.py, all rsynced files are deleted after they are copied. This is because one of the last steps of threaded_rsync.py is to run it all again with --exclude-from referencing a file of all the file names.</p> postgresql-snap - Task #5321 (New): Make postgres a systemd daemonhttps://public.commandprompt.com/issues/53212016-10-28T06:34:00ZIvan Lezhnjov
<p>Running postgres process as a daemon via an automatically generated systemd service file, results in snap utility failing to install a snap package.</p>
<p>The reason for this is because the said snap utility attempts to start all daemons when it is installing a snap package. The package is always installed as root and thus any daemon is run as root too. However, PostgreSQL is not designed to run as root and it actually refuses to. Thus, if a daemon startup fails, installation of a snap package fails too.</p>
<p>Ideally, postgres should be a systemd-managed process but given the clash of design philosophies it currently doesn't work well.</p>
<p>We need to start a dialog with snapcraft developers and see if they can propose a solution to this problem that doesn't involve patching PostgreSQL.</p> postgres_fdw - Bug #5317 (New): Jonie Bittenbenderhttps://public.commandprompt.com/issues/53172016-01-26T22:56:37ZJonie Bittenbenderjoniebitdl@list.ru
<p>Jonie Bittenbender</p> postgres_fdw - Bug #5303 (New): [SPAM] Good shoes good priceshttps://public.commandprompt.com/issues/53032014-05-11T09:24:00ZAlvherre -dntnmh@dng.vnn.vnpostgres_fdw - Bug #5291 (New): Great watches at cut-priceshttps://public.commandprompt.com/issues/52912014-04-11T07:30:00ZJkawasaki -info@atlaspersia.comPL/php - Bug #5260 (New): The function could not return varchar string -- When there is function ...https://public.commandprompt.com/issues/52602011-11-02T23:16:35Zanthony chenzhihong.chen.cn@gmail.com
<p>There is pl/php definition as attached plsimple.sql. Which include other files blank.php.</p>
<p>Run first time:<br />test=# select plsimple();<br /> plsimple<br />----------</p>
<p>(1 row)</p>
<p>test=#<br />Run second time:<br />test=# select plsimple();<br /> plsimple<br />--------------<br /> Hello world!<br />(1 row)</p>
<p>When remove the definition of function test() in the blank.php, the issue disppears.</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 - Bug #5258 (New): Get rid of the trusted PL/PHPhttps://public.commandprompt.com/issues/52582011-05-27T05:43:07ZAlexey Klyukinalexk@commandprompt.com
<p>Apparently, the trusted PL/PHP has lots of security problems due to its trusted status, from sharing the same interpreter with an untrusted one, to <br />the fact that the trusted implementation relies on PHP safe mode, which is deprecated and allows some 'untrusted' (in PG's sense) operations, i.e. filesystem/network access. ATM we need to get rid of PL/PHP and leave only PL/PHPU implementation.</p> PL/php - Bug #5255 (New): support TRUNCATE triggershttps://public.commandprompt.com/issues/52552011-05-21T16:29:20ZÁlvaro Herreraalvherre@commandprompt.com
<p>$SUBJECT</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 - 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>