Re: [GENERAL] Recursive CTE in function problem

ugh, simple syntax screw up. Thanks David. On 02/04/2016 02:45 PM, David G. Johnston wrote: On Thu, Feb 4, 2016 at 12:37 PM, Doug Kyle <mailto:dk...@grpl.org>>wrote: But when I use it as a function it always returns false: CREATE OR REPLACE

[GENERAL] Recursive CTE in function problem

Postgres 9.4.1, with these tables: grpl_collection.collections id | integer | name | text| parent | bigint | (An adjacency list representing a collections hierarchy) grpl_collection.collections_copy_map id | integer | collection | bigint | copy | bigint | (map a

Re: [GENERAL] Performance of PostgreSQL B+-tree algorithm

uessing you would also pay a fixed cost (log (Knuth order)) to traverse a leaf node once you get there. One can probably produce graphs that show how many records one needs in a database table before the page size increase starts to make sense. --Kyle -- Sent via pgsql-general mailing list (pgsq

[GENERAL] Performance of PostgreSQL B+-tree algorithm

s of the PostgreSQL B+-tree implementation. Thanks much, --Kyle -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg 9.0, streaming replication, fail over and fail back strategies

inetd worked, but I feel like I should be able to get iptables to work - do you have any pointers I could follow?) Thanks again, this will most likely sove my vip binding issue. Kyle -- Twitter: @kyleburton Blog: http://asymmetrical-view.com/ Fun: http://snapclean.me/ -- Sent via pgsql-gener

[GENERAL] pg 9.0, streaming replication, fail over and fail back strategies

W) is an obvious one, which will be recognized by corosync and I can script the initiation of failover (including using ipmi to power down the master). Thank you for your time. Kyle Burton -- Twitter: @kyleburton Blog: http://asymmetrical-view.com/ Fun: http://snapclean.me/ -- Sent via pgsql-

[GENERAL] dump error parent table oid of pg_rewrite entry oid not found

I have this error from pg_dumpall: pg_dump: failed sanity check, parent table OID 27974 of pg_rewrite entry OID 28689 not found I found a rule was dropped when this server was setup as s Slony replica because it conflicted with the Slony deny access trigger select oid,rulename from pg_rewrit

Re: [GENERAL] ordered pg_dump

sible. -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Decreasing WAL size effects

ith a small pile of servers running PG)... I would also find any improvements in WAL shipping helpful, between now and when continuous streaming is ready. -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] Decreasing WAL size effects

e in a way that is always on (i.e. no setting, etc.). On the log-recovery side, PG would need to be willing to accept shorter-than-usual segments, if it's not already willing. -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Decreasing WAL size effects

Greg Smith wrote: On Thu, 30 Oct 2008, Kyle Cordes wrote: It sure would be nice if there was a way for PG itself to zero the unused portion of logs as they are completed, perhaps this will make The overhead of clearing out the whole thing is just large enough that it can be disruptive on

Re: [GENERAL] Decreasing WAL size effects

or PG itself to zero the unused portion of logs as they are completed, perhaps this will make it in as part of the ideas discussed on this list a while back to make a more "out of the box" log-ship mechanism? -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-gener

[GENERAL] Need advice on PITR Slony(?) Backups etc.

volve some hours of consulting work. If anyone is interested, get in touch by email, and I will send over a description of what we have and what we're trying to achieve. -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] Can´t connect but listen addr ess and pg_hba configured correctly

stebin.ca/980122 postgresql.conf (connection settings section): http://www.pastebin.ca/980147 PostgreSQL 8.1 Debain Etch package. Any hints greatly appreciated! Marcelo. -- Kyle Wilcox NOAA Chesapeake Bay Office 410 Severn Avenue Suite 107A Annapolis, MD 21403 office: (410) 295-3151

Re: [GENERAL] Trouble with foreign key

_ip| _stamp | _expired | _var --+--+---+-- xx.121.111.31/32 | 2f980de9f2297c7902f3415f6537c6be | 2008-04-08 17:49:33.193914+02 | (1 row) -- Kyle Wilcox NOAA Chesapeake Bay Offic

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

- Original Message - From: Zden?k Kotala <[EMAIL PROTECTED]> Date: Wednesday, March 26, 2008 10:25 am Subject: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...) > Hello All, > > I prepared patch for renaming postgreSQL script tools like > createdb, createuser

Re: [GENERAL] Fail to connect after server crash

are detection / anti-virus software on it, or more complexly, tell > it to ignore the directories where postgresql lives. > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings -- Kyle Wilcox NO

[GENERAL] Fail to connect after server crash

01-04 10:48:49 FATAL: failed to re-find parent key in "47340" for split pages 148155/148160 2008-01-04 10:48:49 LOG: startup process (PID 4864) exited with exit code 1 2008-01-04 10:48:49 LOG: aborting startup due to startup process failure 2008-01-04 10:48:49 LOG: logger shutting down

[GENERAL] Want to help on open-source ERP?

I have a project "wyatterp.com" that was built to be an ERP development library using postgresql as a backend. We use it internally to run a 120 employee manufacturing company. And it does everything from payroll to production management. I haven't been able to do much on it for a while but n

[SQL] Simple insert not returning

.. INSERT INTO tbl_system ( system_name, description ) VALUES ( 'test', 'test system' ); after executing this query, it just sits there and never returns... Am I missing something? -={ Kyle }=- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Job opportunity for PostgreSQL developer

We may be hiring a developer in the next few months to work our our current ERP which is implemented in TCL/TK and PostgreSQL. Anyone interested could send a resume to me. You might also look at an older iteration of part of our work at www.wyatterp.com. Kyle Bateman President, Action Target

[GENERAL] poor performance on 7.1 vs 7.0

;ll have to stick with 7.0. I'm open to suggestions as to what to try here-- and yes, I have vacuum analyzed this database... I can quickly & easily perform tests here, I've got the datasets in pgdump files and have the two machines at my disposal. Regards, Kyle [EMAIL PROTECTED] =~ s

[GENERAL] making functions take arrays

, int num_elements). Is this possible? Also, how do I return an SQL NULL from a function? Thanks, Kyle

[GENERAL] optimizing "between" queries

en ordered by how well they discriminate. Can I use "cluster" on more than one column with indexes per column to improve the search time? How else might I be able to tweak this? thanks, Kyle

[GENERAL] Re: pg_dump problem

appears to be fixed using the '-f' switch: > > mymachine:~$ pg_dump -u [database] -f [somefile] what if you want to pipe the output to your favorite compression utility? I like doing a weekly: pg_dumpall | bzip2 - > dump.bz2 -Kyle

[GENERAL] Re: Problem with inserting newlines and ' characters

data) values ($dbh->quote($sno), $dbh->quote($date), $dbh->quote($tmpstring))"); Hope that helps. Regards, Kyle