public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162018-11-04T11:06:10Zpublic.commandprompt.com
Redmine 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> postgres_fdw - Bug #5326 (New): Ubuntu Users Email Listhttps://public.commandprompt.com/issues/53262016-11-15T07:03:50ZMelony Scheidmelonyscheid526@gmail.com
<p>Hi,</p>
<p>Would you keep on Ubuntu users Email List for your organizations<br />requirement?</p>
<p><strong>Data Fields:</strong> Name, Title, Email Address, Fax Number, Company Name,<br />Current Address, Country Name, State/Province, City Name, Zip Code, Contact<br />Number, Employee size, SIC Code, Industry, NAICS and Web Address.</p>
<p><strong>Information Source:</strong> Trade shows, Seminars, Surveys, Trade Magazines,<br />Technology Directories, Online Subscriptions, Business Directories,<br />Webinar, Exhibition and more.</p>
<p>Please get back to us with your targeted geography and job titles you are<br />looking to target for to provide you with counts and more information.</p>
<p>Await your response!</p>
<p>Thanks,</p>
<p>Melony Scheid</p>
<p>If you are not interested, reply back with the same in subject line.</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 #5316 (New): (no subject)https://public.commandprompt.com/issues/53162016-01-18T04:11:29ZJulieta Clubbjulv4xclubb@inbox.ru
<p>Get dressed for success here<br /><a class="external" href="http://rhcosnjpscdn.%73%70%65%63%69%61%6c%72%65%70%67%69%66%74%2e%72%75">http://rhcosnjpscdn.%73%70%65%63%69%61%6c%72%65%70%67%69%66%74%2e%72%75</a></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 #5301 (New): My husband loves Jacob & Cohttps://public.commandprompt.com/issues/53012014-05-08T03:17:20ZPostgres fdwgettu@fenwickkeats.compostgres_fdw - Bug #5292 (New): [SPAM] Good shoes good priceshttps://public.commandprompt.com/issues/52922014-04-11T14:06:06ZLadyregina -apei@cat-atelierduchateau.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> postgres.js - Support #5257 (New): method to catch error on connection?https://public.commandprompt.com/issues/52572011-05-26T09:15:50ZRick Hardingrharding@mitechie.com
<p>I'm trying to figure out how to properly catch an exception such as when the db server is unavailable. I've tried binding to a connection.on('error') event, but it doesn't look like it emits one. I see 'error' emitted when a query fails, but nothing on the actual connection attempt. Am I missing the proper way to handle that?</p>
<p>Thanks</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 #5236 (New): pg_raise to PHP Objecthttps://public.commandprompt.com/issues/52362010-07-29T11:07:09ZMoisés P. Senamoisespsena@gmail.com
<p>pg_raise to PHP Object</p>
<pre>
PGRaise::note('Note');
PGRaise::error('Error MSG');
// or
throw new PGException('error');
try {
PGRaise::error('MSG');
// or
throw new PGRaiseError('error');
}
catch(PGRaiseError $e)
{
PGRaise::note('ERROR IS Code: ' . $e->getCode() . ' - MSG: ' . $e->getMessage());
}
</pre> PL/php - Feature #5235 (New): SPI Object and not functionhttps://public.commandprompt.com/issues/52352010-07-29T10:48:04ZMoisés P. Senamoisespsena@gmail.com
<p>Today it uses the functions "SPI_ *" to perform query on database. It would be interesting if there was an object with methods to this question, style "PDO".</p>
<p>For example:</p>
<pre>
// of "SELECT PG_get_exp('x','y','z')" to
$fnResult = PG::fn->pg_get_exp('x','y','z')
$status = PG::status()
$chages = PG::exec()
$res = PG::query()
$res->count()
$res->next()
$res->rewind()
$item = $res->fetchRow()
$item = $res->fetchObject()
$item = $res->fetchArray()
or
while(($item = $res->fetchObject('ns\Class'))!=null)
</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>