Re: [HACKERS] idle connection timeout ...

2002-10-26 Thread Alvaro Herrera
On Sat, Oct 26, 2002 at 11:58:35PM -0400, Bruce Momjian wrote: > Alvaro Herrera wrote: > > On Sat, Oct 26, 2002 at 11:12:01PM -0400, Bruce Momjian wrote: > > > > > > Tom's idea of doing this as part of the already added per-user/per-db > > > settings seems like a good direction to take. > > > > Y

Re: [HACKERS] idle connection timeout ...

2002-10-26 Thread Bruce Momjian
Alvaro Herrera wrote: > On Sat, Oct 26, 2002 at 11:12:01PM -0400, Bruce Momjian wrote: > > > > Tom's idea of doing this as part of the already added per-user/per-db > > settings seems like a good direction to take. > > Yes, but how? The current implementation has a setting column in > pg_shadow,

Re: [HACKERS] idle connection timeout ...

2002-10-26 Thread Alvaro Herrera
On Sat, Oct 26, 2002 at 11:12:01PM -0400, Bruce Momjian wrote: > > Tom's idea of doing this as part of the already added per-user/per-db > settings seems like a good direction to take. Yes, but how? The current implementation has a setting column in pg_shadow, and another in pg_database. Is the

[HACKERS] beta3 packaged ...

2002-10-26 Thread Marc G. Fournier
Please check it and confirm ... I believe everything, includin the docs, should be right on this ... if not, I'm going to repackage before announcing ... ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.or

Re: [HACKERS] idle connection timeout ...

2002-10-26 Thread Bruce Momjian
Tom's idea of doing this as part of the already added per-user/per-db settings seems like a good direction to take. --- Marc G. Fournier wrote: > On Fri, 25 Oct 2002, Bruce Momjian wrote: > > > > > I need others wanting thi

Re: [HACKERS] Time for RC1 soon?

2002-10-26 Thread Bruce Momjian
Marc G. Fournier wrote: > On Fri, 25 Oct 2002, Bruce Momjian wrote: > > > > > We are putting out beta3 today or tomorrow. It seems we are ready to > > start considering an RC1 date, perhaps next Friday, November 1? > > tom is away for the week, so I wouldn't see anything earlier hten the week >

Re: [HACKERS] Time for RC1 soon?

2002-10-26 Thread Marc G. Fournier
On Sat, 26 Oct 2002, Thomas Lockhart wrote: > ... and just out of curiosity, why does Bruce's message have a [HACKERS] > tag in the subject line but my reply does not? It seems to be going > through the same mailer but with different results... *puzzled look* both messages arrived here with the

Re: [HACKERS] Time for RC1 soon?

2002-10-26 Thread Marc G. Fournier
On Sat, 26 Oct 2002, Thomas Lockhart wrote: > >>Seems like someone ought to issue a call for port reports. The > >>"supported platforms" list hasn't been touched ... > > Good point. Thomas, can you take that on? > > No, at least not now. I'm not able to communicate reliably with the > mailing li

Re: [HACKERS] Time for RC1 soon?

2002-10-26 Thread Marc G. Fournier
On Fri, 25 Oct 2002, Bruce Momjian wrote: > > We are putting out beta3 today or tomorrow. It seems we are ready to > start considering an RC1 date, perhaps next Friday, November 1? tom is away for the week, so I wouldn't see anything earlier hten the week following tha t... > > ---

Re: [HACKERS] idle connection timeout ...

2002-10-26 Thread Marc G. Fournier
On Fri, 25 Oct 2002, Bruce Momjian wrote: > > I need others wanting this before I can add something of this > sophistication to TODO. Sounds cool to me, and would satisfy what I'm looking for, since it sounds like the same user could have different limits depending on the database they are/were c

Re: [HACKERS] assignment type mismatch complaints

2002-10-26 Thread Larry Rosenman
On Sat, 2002-10-26 at 18:27, Tom Lane wrote: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > How concerned are we about assignment type mismatch warnings? > > They're probably all "char versus unsigned char" complaints? Probably. The first few I looked at are PG_GETARG_CSTRING to unsigned char

Re: [HACKERS] assignment type mismatch complaints

2002-10-26 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes: > How concerned are we about assignment type mismatch warnings? They're probably all "char versus unsigned char" complaints? There are a ton of them on compilers that care about it; most of 'em in the multibyte support. While it would be nice to clean

Re: [HACKERS] UnixWare 7.1.3: with current CVS, and cc -Xb.,..

2002-10-26 Thread Bruce Momjian
Update as you suggested: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Larry Rosenman wrote: > On Sat, 2002-10-26 at 15:11, Bruce Momjian wrote: > > > > Updated: > > > > http://candle.ph

Re: [HACKERS] UnixWare 7.1.3: with current CVS, and cc -Xb.,..

2002-10-26 Thread Larry Rosenman
On Sat, 2002-10-26 at 15:11, Bruce Momjian wrote: > > Updated: > > http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html the illustrious marketing folks at The SCO group (nee Caldera) have renamed this OS back to UnixWare. You may want to change the first column back to Uni

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Bruce Momjian
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Alvaro Herrera wrote: > On Sat, Oct 26, 2002 at 04:01:17PM -0400, Bruce Momjian wrote: > > > > Updated: > > > > http://c

Re: [HACKERS] assignment type mismatch complaints

2002-10-26 Thread Bruce Momjian
Can you send over a list of the errors and we will check them out. --- Larry Rosenman wrote: > How concerned are we about assignment type mismatch warnings? > > I got a bunch in the mb stuff, and some in other places from

Re: [HACKERS] UnixWare 7.1.3: with current CVS, and cc -Xb.,..

2002-10-26 Thread Bruce Momjian
Updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Larry Rosenman wrote: > We pass all regression test. > > this is UnixWare 7.1.3, with the native cc compiler. > > > -- > Larry Ro

Re: [HACKERS] idle connection timeout ...

2002-10-26 Thread Bruce Momjian
Bruno Wolff III wrote: > On Sat, Oct 26, 2002 at 01:04:55 -0400, > Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > The per db/user stuff is stored in the pg_database/pg_shadow tables per > > row, so they exist in permanent storage. > > I have a question about this. This stuff is per user OR pe

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Alvaro Herrera
On Sat, Oct 26, 2002 at 04:01:17PM -0400, Bruce Momjian wrote: > > Updated: > > http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html Linux 2.4 on IA32 passes also. -- Alvaro Herrera () "La felicidad no es maƱana. La felicidad es ahora" ---(end of

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Bruce Momjian
Updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Doug McNaught wrote: > Doug McNaught <[EMAIL PROTECTED]> writes: > > > OK, compile went fine, but I get multiple regression test failu

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Bruce Momjian
Updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Folks. start sending in those plaform reports, OS name and version >

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Doug McNaught
Doug McNaught <[EMAIL PROTECTED]> writes: > OK, compile went fine, but I get multiple regression test failures: > > test geometry ... FAILED After realizing that my disk had filled up (thanks Alvaro) I reran the tests and 'geometry' is the only failure. I'm guessing this is due to f

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Stephan Szabo
On 26 Oct 2002, Doug McNaught wrote: > Tom Lane <[EMAIL PROTECTED]> writes: > > > Doug McNaught <[EMAIL PROTECTED]> writes: > > > make[3]: Entering directory >`/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs/ascii_and_mic' > > > gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declaration

[HACKERS] Turning the PLANNER off

2002-10-26 Thread Ben McMahan
I'm looking at different ways of optimizing queries with a large number of joins. I write the same query in a number of different ways and compare the running times. Now the problem is I do not want the optimizer changing the queries. So I explicit state the order of the joins in the FROM clause

[HACKERS] assignment type mismatch complaints

2002-10-26 Thread Larry Rosenman
How concerned are we about assignment type mismatch warnings? I got a bunch in the mb stuff, and some in other places from the UnixWare 7.1.3 compiler. We still pass all regression tests. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812

[HACKERS] UnixWare 7.1.3: with current CVS, and cc -Xb.,..

2002-10-26 Thread Larry Rosenman
We pass all regression test. this is UnixWare 7.1.3, with the native cc compiler. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 -

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Doug McNaught
Tom Lane <[EMAIL PROTECTED]> writes: > Doug McNaught <[EMAIL PROTECTED]> writes: > > make[3]: Entering directory >`/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs/ascii_and_mic' > > gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic > > -I../../../../../../src/include -c

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Tom Lane
Doug McNaught <[EMAIL PROTECTED]> writes: > make[3]: Entering directory >`/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs/ascii_and_mic' > gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic > -I../../../../../../src/include -c -o ascii_and_mic.o > ascii_and_mic.c > ascii_

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Doug McNaught
Tom Lane <[EMAIL PROTECTED]> writes: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Folks. start sending in those plaform reports, OS name and version > > number please. > > I've checked CVS tip on: > HPUX 10.20, using both gcc and vendor's cc > PPC Linux > Mac OS X 10.1 I get

Re: [HACKERS] UnixWare 7.1.3 (BETA), C99 compiler, current CVS, error...

2002-10-26 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes: >> so the text of the message is surely not what they are really >> complaining about? Or is the compiler broken? > I'll ask, it is Beta (although the Compiler has done this since the C99 > functionality was added, and it causes a LOT of open source stuff

Re: [HACKERS] UnixWare 7.1.3 (BETA), C99 compiler, current CVS,

2002-10-26 Thread Larry Rosenman
On Sat, 2002-10-26 at 10:07, Tom Lane wrote: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Without specifying the -Xb switch to kill the C99 interpretation of > > inline, I get the following from current CVS: > > > UX:acomp: ERROR: "tuplesort.c", line 1854: "inline" functions cannot use > > "st

Re: [HACKERS] UnixWare 7.1.3 (BETA), compile error (with cc -Xb)

2002-10-26 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes: > With cc -Xb, we get farther, but still die (CURRENT CVS): > cc -Xb -O -g -K PIC -I../../../../../../src/include -I/usr/local/include -c -o >ascii_and_mic.o ascii_and_mic.c > UX:cc: WARNING: debugging and optimization mutually exclusive; -O disable

Re: [HACKERS] UnixWare 7.1.3 (BETA), C99 compiler, current CVS, error...

2002-10-26 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes: > Without specifying the -Xb switch to kill the C99 interpretation of > inline, I get the following from current CVS: > UX:acomp: ERROR: "tuplesort.c", line 1854: "inline" functions cannot use > "static" identifier: myFunctionCall2 I don't understand wha

[HACKERS] UnixWare 7.1.3 (BETA), compile error (with cc -Xb)

2002-10-26 Thread Larry Rosenman
With cc -Xb, we get farther, but still die (CURRENT CVS): cc -Xb -O -g -K PIC -I../../../../../../src/include -I/usr/local/include -c -o ascii_and_mic.o ascii_and_mic.c UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled UX:acomp: ERROR: "ascii_and_mic.c", line 19: sy

[HACKERS] UnixWare 7.1.3 (BETA), C99 compiler, current CVS, error...

2002-10-26 Thread Larry Rosenman
Without specifying the -Xb switch to kill the C99 interpretation of inline, I get the following from current CVS: UX:acomp: ERROR: "tuplesort.c", line 1854: "inline" functions cannot use "static" identifier: myFunctionCall2 UX:acomp: ERROR: "tuplesort.c", line 1856: "inline" functions cannot use "

Re: [HACKERS] Request for supported platforms

2002-10-26 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Folks. start sending in those plaform reports, OS name and version > number please. I've checked CVS tip on: HPUX 10.20, using both gcc and vendor's cc PPC Linux Mac OS X 10.1 regards, tom lane --