Re: [HACKERS] Simple thing to make pg_autovacuum more useful

2008-01-18 Thread Magnus Hagander
On Fri, Jan 18, 2008 at 01:07:27AM +, Gregory Stark wrote: > "Tom Lane" <[EMAIL PROTECTED]> writes: > > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >> You are offering what appears to be a "solution". A perfectly valid one > >> in fact. Which one is going to get done first? Which one is

Re: [HACKERS] Simple thing to make pg_autovacuum more useful

2008-01-18 Thread Dave Page
On 18/01/2008, Gregory Stark <[EMAIL PROTECTED]> wrote: > Are you picturing adding ALTER TABLE commands to set autovacuum parameters? Or > do you mean for tools like pgadmin to control this? Because the latter could > happen even during the 8.3 cycle (though I perhaps not with pgadmin itself > whic

Re: [HACKERS] Simple thing to make pg_autovacuum more useful

2008-01-18 Thread Darcy Buskermolen
On Thursday 17 January 2008 19:17:00 Joshua D. Drake wrote: > On Thu, 17 Jan 2008 21:43:46 -0300 > > Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > Tom Lane wrote: > > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > > > All this thread is a waste of time. We've previously agreed that > > > > we're

Re: [HACKERS] modularity of PostgreSQL

2008-01-18 Thread Jonah H. Harris
On Jan 18, 2008 8:09 AM, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > On Jan 17, 2008 6:46 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > > Uh, does anyone authoritative describe it that way? I think we can > > legitimately claim that Postgres is pretty extensible, but as for > > modularity I'm not sur

Re: [HACKERS] proposal: generic function, constructor function

2008-01-18 Thread Pavel Stehule
On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote: > "Pavel Stehule" <[EMAIL PROTECTED]> writes: > > I propose two kinds of functions: > > > a) generic functions - this function allows any params without any > > implicit casting (it can implemented only in C language). > > Can't you do that already

Re: [HACKERS] Recent pg_regress changes break testing under SELinux

2008-01-18 Thread Alvaro Herrera
Tom Lane wrote: > Who decided this part of pg_regress.c was a good idea? > > /* try to create the test tablespace dir if it doesn't exist */ > snprintf(testtablespace, MAXPGPATH, "%s/testtablespace", abs_builddir); > if (directory_exists(testtablespace)) > rmtree(te

Re: [HACKERS] Recent pg_regress changes break testing under SELinux

2008-01-18 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> The original design had only the Makefile knowing exactly where the >> testtablespace directory lurks, making it changeable in one place, >> and also confining the whole business to src/test/regress which is good >> because none of th

Re: [HACKERS] Recent pg_regress changes break testing under SELinux

2008-01-18 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > Yeah, agreed. The original idea was to have a shortcut created by the > installer to do that for you. > ... > Well, there is a way to run it from the msvc build. The idea was to be > able to run after a binary install. Granted it doesn't make that muc

Re: [HACKERS] proposal: generic function, constructor function

2008-01-18 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > But I am not able create function with > ANY params. Is it possible do it via CREATE FUNCTION .. ? It's a reserved word :-(. Try "any" regards, tom lane ---(end of broadcast)--

[HACKERS] Traveling to London

2008-01-18 Thread Bruce Momjian
FYI, I am leaving for London tomorrow/Saturday to do training for EnterpriseDB and a breakfast event: http://momjian.us/main/events.html I return next Friday, January 25. I will try to keep current on email while I am away. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.

Re: [HACKERS] Traveling to London

2008-01-18 Thread Gottfried F. Zojer
Save trip ,enjoy the flight and please bring a big umbrella its raining here. Gottfried www.5152.co.uk On 1/19/08, Bruce Momjian <[EMAIL PROTECTED]> wrote: > FYI, I am leaving for London tomorrow/Saturday to do training for > EnterpriseDB and a breakfast event: > > http://momjian.us/main/e

Re: [HACKERS] Recent pg_regress changes break testing under SELinux

2008-01-18 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander <[EMAIL PROTECTED]> writes: Tom Lane wrote: The original design had only the Makefile knowing exactly where the testtablespace directory lurks, making it changeable in one place, and also confining the whole business to src/test/regress which is good because none

Re: [HACKERS] Recent pg_regress changes break testing under SELinux

2008-01-18 Thread Magnus Hagander
Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Tom Lane wrote: Who decided this part of pg_regress.c was a good idea? Hmm, AFAICS it was applied by me in 1.26, a patch from Magnus apparently. This was quite some time ago! I think I just passed that part verbatim from Magnus' pa

Re: [HACKERS] proposal: generic function, constructor function

2008-01-18 Thread Pavel Stehule
On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote: > "Pavel Stehule" <[EMAIL PROTECTED]> writes: > > On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote: > >> Can't you do that already with ANYELEMENT, or at the worst ANY? > > > I would to have independent parameters and move type checking to > > fun

Re: [HACKERS] proposal: generic function, constructor function

2008-01-18 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > I propose two kinds of functions: > a) generic functions - this function allows any params without any > implicit casting (it can implemented only in C language). Can't you do that already with ANYELEMENT, or at the worst ANY? > It allows unspecified

[HACKERS] proposal: generic function, constructor function

2008-01-18 Thread Pavel Stehule
Hello I propose two kinds of functions: a) generic functions - this function allows any params without any implicit casting (it can implemented only in C language). This function have to have specified return type. It usable for constructor function and for some other. It allows unspecified numbe

Re: [HACKERS] modularity of PostgreSQL

2008-01-18 Thread Jonah H. Harris
On Jan 17, 2008 6:46 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Uh, does anyone authoritative describe it that way? I think we can > legitimately claim that Postgres is pretty extensible, but as for > modularity I'm not sure that it's got any great claim to fame. > To me modularity connotes an emph

[HACKERS] Problem with correct compiling and linking server side C function on Windows ,c++ Builder

2008-01-18 Thread Maciej Grygorcewicz
Hello I tried to find soultion for this problem on -cygwin list , but there they sent me to teh list -win32. But I foun on the site that this is that list (also -hacker-win32),so I came here to -hackers. My problem is as follows , maybe you can help me: I ma working on a server-side funct

Re: [HACKERS] testing result overview (was: 8.3 beta testing suggestions welcome)

2008-01-18 Thread Kevin Grittner
>>> On Tue, Aug 21, 2007 at 1:12 PM, in message <[EMAIL PROTECTED]>, Greg Smith <[EMAIL PROTECTED]> wrote: > My suggestion for a starting 8.3 configuration for you would be adjusting > these settings as follows: > > shared_buffers=1GB > checkpoint_segments = 50 > > And then try replaying you

[HACKERS] Recent pg_regress changes break testing under SELinux

2008-01-18 Thread Tom Lane
Who decided this part of pg_regress.c was a good idea? /* try to create the test tablespace dir if it doesn't exist */ snprintf(testtablespace, MAXPGPATH, "%s/testtablespace", abs_builddir); if (directory_exists(testtablespace)) rmtree(testtablespace, true);

Re: [HACKERS] Recent pg_regress changes break testing under SELinux

2008-01-18 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Who decided this part of pg_regress.c was a good idea? > Hmm, AFAICS it was applied by me in 1.26, a patch from Magnus > apparently. This was quite some time ago! I think I just passed that > part verbatim from Magnus' patch. Hmm .

Re: [HACKERS] proposal: generic function, constructor function

2008-01-18 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > On 18/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote: >> Can't you do that already with ANYELEMENT, or at the worst ANY? > I would to have independent parameters and move type checking to > function. Okay, then you want ANY. > Then I don't need register

Re: [HACKERS] Traveling to London

2008-01-18 Thread Josh Berkus
Bruce, > FYI, I am leaving for London tomorrow/Saturday to do training for > EnterpriseDB and a breakfast event: Right when I'm coming to New York, too. Darn it! (I'll be in NYC Jan 21-25). -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)