[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

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) + { +

[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=99694

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 Surely this

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 this better than:

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 that

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-atime now;

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 the

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. Applied with

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 Changes

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: [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 mail

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=99694 So why

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 evening at