Re: [PATCHES] [HACKERS] 8.2 features?

2006-07-28 Thread Joe Conway
Joe Conway wrote: Tom Lane wrote: I thought Joe was off in a corner doing a whole new version. (I'm willing to help if he needs help...) Yeah, I was going to post the latest tonight. Sorry for the delay. Ever see the movie "The Money Pit"? This afternoon I started to think I lived in that h

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> Tom Lane wrote: > >>> The cases that I think we most need to defend against are > >>> (A) diff program not found > > > In summary, on MinGW, files differ or 'diff' not found, returns 1. If > > one of the files to be compared does no

Re: [HACKERS] [PATCHES] [PATCH] Provide 8-byte transaction IDs to user level

2006-07-28 Thread Marko Kreen
On 7/27/06, Darcy Buskermolen <[EMAIL PROTECTED]> wrote: In one of those 3am lightbulbs I belive I have a way to make use of the 64-bit XID counter and still maintain the ability to have backwards compatibility. Is there any chance you could break this patch up into the 2 separate componenets tha

Re: [PATCHES] [HACKERS] 8.2 features?

2006-07-28 Thread Joe Conway
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: Are you going to apply this? Seems it is ready. I thought Joe was off in a corner doing a whole new version. (I'm willing to help if he needs help...) Yeah, I was going to post the latest tonight. I'm afraid though that after 2 or

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: >>> The cases that I think we most need to defend against are >>> (A) diff program not found > In summary, on MinGW, files differ or 'diff' not found, returns 1. If > one of the files to be compared does not exist, it returns 2. And of

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Bruce Momjian
Bruce Momjian wrote: > Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > I checked on MinGW and system() just returns the value returned by the > > > application. There isn't any special two-values-in-one layering like is > > > done on Unix for wait() and the return value from sy

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I checked on MinGW and system() just returns the value returned by the > > application. There isn't any special two-values-in-one layering like is > > done on Unix for wait() and the return value from system(). It seems if > > the ch

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I checked on MinGW and system() just returns the value returned by the > application. There isn't any special two-values-in-one layering like is > done on Unix for wait() and the return value from system(). It seems if > the child dies from a signal, th

Re: [PATCHES] [HACKERS] 8.2 features?

2006-07-28 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Are you going to apply this? Seems it is ready. > > I thought Joe was off in a corner doing a whole new version. > (I'm willing to help if he needs help...) OK, just checking. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB

Re: [PATCHES] [HACKERS] 8.2 features?

2006-07-28 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Are you going to apply this? Seems it is ready. I thought Joe was off in a corner doing a whole new version. (I'm willing to help if he needs help...) regards, tom lane ---(end of broadcast)-

Re: [PATCHES] [HACKERS] 8.2 features?

2006-07-28 Thread Bruce Momjian
Are you going to apply this? Seems it is ready. --- Joe Conway wrote: > Tom Lane wrote: > > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > > > >>Strange. Last time I checked I thought MySQL dump used 'multivalue >

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > *** src/test/regress/pg_regress.c 27 Jul 2006 15:37:19 - 1.16 > > --- src/test/regress/pg_regress.c 28 Jul 2006 19:01:12 - > > *** > > *** 813,823 > > * work for inspecting the results of system()

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > *** src/test/regress/pg_regress.c 27 Jul 2006 15:37:19 - 1.16 > --- src/test/regress/pg_regress.c 28 Jul 2006 19:01:12 - > *** > *** 813,823 >* work for inspecting the results of system(). For the moment, >

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Bruce Momjian
Tom Lane wrote: > "Hiroshi Saito" <[EMAIL PROTECTED]> writes: > > This is very strange.!! > > boolean ... ok > > char ... diff command failed with status 1: "diff -w > > "./expected/char.out" > > "./results/char.out" >"./results/char.diff"" > > server stoppe

Re: [HACKERS] [PATCHES] Resurrecting per-page cleaner for btree

2006-07-28 Thread Jim C. Nasby
On Thu, Jul 27, 2006 at 05:24:35PM -0400, Greg Stark wrote: > > Jim Nasby <[EMAIL PROTECTED]> writes: > > > Even if we stopped right there it would still be a huge win in many (most?) > > cases. How often do the indexes on a table comprise even 50% of the table's > > size? > > I would say the

Re: [HACKERS] [PATCHES] pgstattuple extension for indexes

2006-07-28 Thread Bruce Momjian
Alvaro Herrera wrote: > Bruce Momjian wrote: > > > > I thought these new functions were going to be merged into > > /contrib/pgstattuple. > > Well, that's exactly what this patch seems to do ... Well, looking at the tarball it puts everything in pgstatindex, and the Makefile is: #-

Re: [HACKERS] [PATCHES] pgstattuple extension for indexes

2006-07-28 Thread Alvaro Herrera
Bruce Momjian wrote: > > I thought these new functions were going to be merged into > /contrib/pgstattuple. Well, that's exactly what this patch seems to do ... -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.

[PATCHES] PL instrumentation plugin support (i.e. PL/pgSQL debugger infrastructure)

2006-07-28 Thread [EMAIL PROTECTED]
The attached patch adds support for loadable instrumentation plugins for procedural languages (as discussed at the anniversary summit). It also adds plugin support to the PL/pgSQL language handler. We are using this plugin mechanism to load the PL/pgSQL debugger on demand (the debugger is not

[PATCHES] regression tests for guc SET

2006-07-28 Thread Joachim Wieland
Zdenek Kotala sent in regression tests for SET a few days ago which got turned down. I think however that the idea has merit and that only his implementation was not useful. Attached is another regression test script that executes some SET / SET LOCAL within transactions and subtransactions. Joa

Re: [PATCHES] pgstattuple extension for indexes

2006-07-28 Thread Bruce Momjian
I thought these new functions were going to be merged into /contrib/pgstattuple. --- satoshi nagayasu wrote: > Hi folks, > > As I said on -PATCHES, I've been working on an utility to get > a b-tree index information. I'm ha

Re: [HACKERS] [PATCHES] putting CHECK_FOR_INTERRUPTS in qsort_comparetup()

2006-07-28 Thread Tom Lane
"Charles Duffy" <[EMAIL PROTECTED]> writes: > ... For the 'long' data, the compare moves on rightward until it > encounters 'flato', which is a TEXT column with an average length of > 7.5k characters (with some rows up to 400k). The first 6 columns are > mostly INTEGER, so compares on them are rela

[PATCHES] selecting large result sets in psql using cursors

2006-07-28 Thread Chris Mair
Hi there, attached is the new and fixed version of the patch for selecting large result sets from psql using cursors. It was previously discussed on hackers: http://archives.postgresql.org/pgsql-hackers/2006-07/msg00231.php Thanks again to Neil Conway for helping with this (the first sketch of t

Re: [HACKERS] [PATCHES] putting CHECK_FOR_INTERRUPTS in qsort_comparetup()

2006-07-28 Thread Charles Duffy
On 7/15/06, Tom Lane <[EMAIL PROTECTED]> wrote: Anyway, Qingqing's question still needs to be answered: how can a sort of under 30k items take so long? It happens because (as previously suggested by Tom) the dataset for the 'short' (~10k rows, .3 sec) sort has no rows whose leftmost fields eva

Re: [PATCHES] extension for sql update

2006-07-28 Thread Susanne Ebrecht
Am Donnerstag, den 27.07.2006, 08:30 -0400 schrieb Tom Lane: > Susanne Ebrecht <[EMAIL PROTECTED]> writes: > > ... We could provide the mixed update syntax and leave the > > typed row value expression for the next release. Do you agree? > > I don't really see the point --- the patch won't provide