Re: [HACKERS] [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-08 Thread Robert Creager
On Jun 7, 2011, at 12:42 PM, Alex Hunsaker wrote: > On Tue, Jun 7, 2011 at 12:22, Tom Lane wrote: >> Alex Hunsaker writes: >>> Im looking at the "raw" perl 5.10.0 source... I wonder if apple is >>> shipping a modified version? >> >> You could find out by digging around at >> http://www.openso

Re: [HACKERS] reindex creates predicate lock on index root

2011-06-08 Thread Dan Ports
On Tue, Jun 07, 2011 at 10:14:30PM -0400, Tom Lane wrote: > Do you mean page zero, as in the metapage (for most index types), or do > you mean the root page? If the former, how is that not an outright bug, > since it corresponds to no data? If the latter, how is that not a > serious performance p

[HACKERS] SSI heap_insert and page-level predicate locks

2011-06-08 Thread Heikki Linnakangas
heap_insert() calls CheckForSerializableConflictIn(), which checks if there is a predicate lock on the whole relation, or on the page we're inserting to. It does not check for tuple-level locks, because there can't be any locks on a tuple that didn't exist before. AFAICS, the check for page lo

Re: [HACKERS] [PATCH] Bug in XPATH() if expression returns a scalar value

2011-06-08 Thread Florian Pflug
On Jun6, 2011, at 14:56 , Peter Eisentraut wrote: > On tis, 2011-05-31 at 16:19 +0200, Florian Pflug wrote: >> If people deem this to be a problem, we could instead add a separate >> function XPATH_VALUE() that returns VARCHAR, and make people use that >> for scalar-value-returning expressions. >

<    1   2