[HACKERS] Recent buildfarm failures involving statement_timeout

2008-04-26 Thread Tom Lane
The buildfarm has shown several intermittent failures recently: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=heron&dt=2008-04-20%2000:06:01 http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=cobra&dt=2008-04-26%2004:15:02 http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=heron&dt=2008-04-27%20

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Andrew Sullivan
On Sat, Apr 26, 2008 at 08:54:46AM -0700, Joshua D. Drake wrote: > > How would he know to search at the archives? > > * There is no archives signature at the bottom of -hackers lists Maybe because there's a perfectly functional archive link in the mail headers? And because there's an RFC that te

[HACKERS] Traveling this week

2008-04-26 Thread Bruce Momjian
I am leaving tomorrow/Sunday for a one-week trip for EnterpriseDB to Mineapolis and Los Angeles. I will be offline most of the trip so I will miss the start of the May commit fest. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: How would he know to search at the archives? If he knew enough about the community to post in -hackers (as opposed to, say, -general or -novice) he should certainly have heard of the You think so? (not being sarcastic). mailing

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > How would he know to search at the archives? If he knew enough about the community to post in -hackers (as opposed to, say, -general or -novice) he should certainly have heard of the mailing list archives. *You* might find 'em useless but I don't.

Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing

2008-04-26 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Alvaro Herrera wrote: >> Another alternative would be internally creating a different temporary >> enum, rewriting the tables one by one each on its own transaction, and >> finish by dropping the original enum and renaming the temporary one. >> This solv

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I don't see that behavior here on Ubuntu 7.10: > $ COLUMNNS=120 ls -C |cat > archive cdinitrd lost+found proc srv usr > basement.usr dev initrd.img media root sys var > bin etc laptop

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Joshua D. Drake
Andrew Dunstan wrote: I entered "bugzilla" on the archives search page and got this link, right out of the recent discussion, at the top of the list: http://archives.postgresql.org/pgsql-hackers/2008-04/msg00764.php That and a few similar results might have given the OP some hints about wha

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Andrew Dunstan
Joshua D. Drake wrote: Brendan Jurd wrote: Having done that, please endeavour to make an actual contribution to the discussion. Hi Andrew, Let's be fair. It would be an almost impossible task to make any sense of the archives on this topic without dedicating tens of hours to the task,

Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing

2008-04-26 Thread Andrew Dunstan
Alvaro Herrera wrote: Andrew Dunstan escribió: Tom Dunstan wrote: So two alternative proposals, both with a 2 byte "enum id" and a 2 byte "value": 1 - We space the values out as evenly as we can across the 65000ish range and allow people to delete, insert and append, but not reorder

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Joshua D. Drake
Brendan Jurd wrote: Having done that, please endeavour to make an actual contribution to the discussion. Hi Andrew, Let's be fair. It would be an almost impossible task to make any sense of the archives on this topic without dedicating tens of hours to the task, and having access to a bett

Re: [HACKERS] FSM fill ratio

2008-04-26 Thread Alvaro Herrera
Jacques Caron wrote: > Hi all, > > Quick question: is there currently a way to see how many slot are used in > the FSM (i.e. how many free pages are stored there), or how many are > free? If not, wouldn't it be a good idea to add this somewhere? (Don't > quite know where... is it possible to hav

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote: > Oops, Alvaro pointed out I typo'ed the variable name COLUMNS as > COLUMNNS. I see now that 'ls -C' does honor columns. See my later > posting about '\pset wrapped 0' as a special case where we could honor > the ioctl/COLUMNS case. > > My real confusion is this: > > $

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Aidan Van Dyk
* Bruce Momjian <[EMAIL PROTECTED]> [080426 09:44]: > Why does the first 'ls' not honor columns while the second does? How > does 'ls' detect that the COLUMNS=120 is somehow different from the > default COLUMNS value? I would hazard a guess that COLUMNS isn't "exported" from your shell environme

Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing

2008-04-26 Thread Alvaro Herrera
Andrew Dunstan escribió: > Tom Dunstan wrote: >> So two alternative proposals, both with a 2 byte "enum id" and a 2 byte >> "value": >> >> 1 - We space the values out as evenly as we can across the 65000ish >> range and allow people to delete, insert and append, but not reorder. >> If they do the

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote: > Gregory Stark wrote: > I don't see that behavior here on Ubuntu 7.10: > > $ COLUMNNS=120 ls -C |cat > archive cdinitrd lost+found proc srv usr > basement.usr dev initrd.img media root sys var > bin etc laptop

Re: [HACKERS] Tech details - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote: > Hey, I can work with this idea. First, there really is no 'off' mode > for wrapped because that is aligned. What we could do is to have: > > \pset format wrapped display > > affect only output to the screen, using the screen width, and: > > \pset format wrapp

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Gregory Stark wrote: > > [Just when I thought I was out, they pull me back in -- argh, I'm weak] > > "Bruce Momjian" <[EMAIL PROTECTED]> writes: > > > FYI, ls -C actually wraps to 72(?) unless you specify another width, > > I told you exactly what ls did, at least GNU ls. It uses -w if specifi

Re: [HACKERS] MERGE Specification

2008-04-26 Thread Hannes Dorbath
Simon Riggs wrote: On Fri, 2008-04-25 at 10:03 +0300, Hannu Krosing wrote: On Tue, 2008-04-22 at 00:24 +0100, Simon Riggs wrote: On Mon, 2008-04-21 at 16:38 -0400, A.M. wrote: "MERGE will not invoke Rules." Does this imply that MERGE cannot be used on views or that the resulting INSERTs or U