Re: [PATCHES] Time zone definitions to config files

2006-07-25 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > On Mon, Jul 24, 2006 at 11:59:34PM -0400, Tom Lane wrote: >> The documentation is still in need of help ... in particular, Table >> B-4 (timezone names) is now out of sync with reality. > I'll take a whack at that patch this evening PDT or tomorrow evenin

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

2006-07-25 Thread Bruce Momjian
Tom, I ran your tests with fsync off (as you did), and saw numbers bouncing between 400-700 tps without my patch, and sticking at 700 tps with my patch. --- Bruce Momjian wrote: > > The attached patch requires the new row t

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

2006-07-25 Thread Bruce Momjian
The attached patch requires the new row to fit, and 10% to be free on the page. Would someone test that? --- Tom Lane wrote: > ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > > This is a revised patch originated by Junji TER

Re: [PATCHES] Patch for VS.Net 2005's strxfrm() bug

2006-07-25 Thread William ZHANG
"Tom Lane" <[EMAIL PROTECTED]> > "William ZHANG" <[EMAIL PROTECTED]> writes: >> When I tried to compile pgsql-8.2devel with VS.Net 2005 and do regression >> tests, >> I found the problem. It's a bug inVS.Net 2005: >> http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=99

Re: [Fwd: Re: [PATCHES] Patch for - Change LIMIT/OFFSET to use int8]

2006-07-25 Thread Bruce Momjian
Patch applied. Thanks. It had quite a number of tab/space alignment problems that I fixed. --- Dhanaraj M wrote: > I sent this patch already. > Can somebody verify this patch? > > Thanks > Dhanaraj -- Start of included

Re: [PATCHES] Patch for updatable views

2006-07-25 Thread Jaime Casanova
On 7/25/06, Bernd Helmle <[EMAIL PROTECTED]> wrote: Hi folks, please find attached an implementation for updatable views. Included are support for pg_dump and information_schema, regression test and documentation are missing. Also, there's currently no upgrade path for older PostgreSQL versions

Re: [PATCHES] Final version of my cube patch - fixed test cases,

2006-07-25 Thread Bruce Momjian
Patch applied. Thanks. --- Joshua Reich wrote: > Any committers want to take ownership of this? > > Thanks, > > Joshua Reich > > > > C

Re: [PATCHES] Time zone definitions to config files

2006-07-25 Thread David Fetter
On Mon, Jul 24, 2006 at 11:59:34PM -0400, Tom Lane wrote: > "Joachim Wieland" <[EMAIL PROTECTED]> writes: > > Here's the patch that generalizes the australian_timezones hack by > > moving the compiled-in time zone definitions into a text file. The > > text file to use is chosen via a guc. > > Appl

Re: [PATCHES] LDAP lookup of connection parameters

2006-07-25 Thread Bruce Momjian
Albe Laurenz wrote: > This patch for libpq allows you to enter an LDAP URL in pg_service.conf. > The URL will be queried and the resulting string(s) parsed for > keyword = value connection options. > > The idea is to have connection information stored centrally on an LDAP > server rather than on t

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

2006-07-25 Thread Tom Lane
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > This is a revised patch originated by Junji TERAMOTO for HEAD. > [BTree vacuum before page splitting] > http://archives.postgresql.org/pgsql-patches/2006-01/msg00301.php > I think we can resurrect his idea because we will scan btree pages > at-atim

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

2006-07-25 Thread Tom Lane
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > I think we can resurrect his idea because we will scan btree pages > at-atime now; the missing-restarting-point problem went away. > Have I missed something? Comments welcome. I was thinking for awhile just now that this would break the interlock tha

Re: [HACKERS] [PATCHES] Patch for VS.Net 2005's strxfrm() bug

2006-07-25 Thread Hiroshi Saito
From: "Andrew Dunstan" > Hiroshi Saito wrote: > > Hmm, It seems to be the bug of very unpleasant Microsoft.:D > > I think that the following is desirable as an evasion measure to add. > > > > #if defined(_MSC_VER) && _MSC_VER == 1400 > > > > To be sure, it was only VS2005. > > > > > Why is t

Re: [HACKERS] [PATCHES] Patch for VS.Net 2005's strxfrm() bug

2006-07-25 Thread Andrew Dunstan
Hiroshi Saito wrote: > Hmm, It seems to be the bug of very unpleasant Microsoft.:D > I think that the following is desirable as an evasion measure to add. > > #if defined(_MSC_VER) && _MSC_VER == 1400 > > To be sure, it was only VS2005. > Why is this better than: #if _MSC_VER == 1400 Sur

[PATCHES] Patch for updatable views

2006-07-25 Thread Bernd Helmle
Hi folks, please find attached an implementation for updatable views. Included are support for pg_dump and information_schema, regression test and documentation are missing. Also, there's currently no upgrade path for older PostgreSQL versions and user defined rules on views. I have some code

Re: [HACKERS] [PATCHES] Patch for VS.Net 2005's strxfrm() bug

2006-07-25 Thread Hiroshi Saito
Hi. "William ZHANG" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > When I tried to compile pgsql-8.2devel with VS.Net 2005 and do regression > tests, > I found the problem. It's a bug inVS.Net 2005: > http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=9

Re: [PATCHES] Patch for VS.Net 2005's strxfrm() bug

2006-07-25 Thread Tom Lane
"William ZHANG" <[EMAIL PROTECTED]> writes: > When I tried to compile pgsql-8.2devel with VS.Net 2005 and do regression > tests, > I found the problem. It's a bug inVS.Net 2005: > http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=99694 So why don't you use the fixed

[PATCHES] Patch for VS.Net 2005's strxfrm() bug

2006-07-25 Thread William ZHANG
When I tried to compile pgsql-8.2devel with VS.Net 2005 and do regression tests, I found the problem. It's a bug inVS.Net 2005: http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=99694 -- With regards, William ZHANG begin 666 strxfrm.patch M*BHJ('!G&9R;6QE;B ]('-T

Re: [PATCHES] Patch for units in postgresql.conf

2006-07-25 Thread Alvaro Herrera
Peter Eisentraut wrote: > + if ((flags & (GUC_UNIT_KB|GUC_UNIT_BLOCKS)) && endptr != value) > + { > + bool used = false; > + > + while (*endptr == ' ') > + endptr++; > + > + if (strcmp(endptr, "kB") == 0) > + { > +

Re: [PATCHES] Patch for units in postgresql.conf

2006-07-25 Thread Peter Eisentraut
Am Dienstag, 25. Juli 2006 15:12 schrieb Alvaro Herrera: > Does this mean that one must match the "kB" exactly, with the specified > upper and lower case? I think it's better to require exact spelling of the units, or else it'll quickly get inconsistent and error-prone. (Say, if you want to allo

[PATCHES] Patch for units in postgresql.conf

2006-07-25 Thread Peter Eisentraut
Here is a preliminary patch for units in postgresql.conf (and SET and so on, of course). It currently supports memory units only. Time units would be similar. Let me know if you have comments. (FWIW, work_mem is a good parameter to play with for trying this out.) -- Peter Eisentraut http://