Re: [HACKERS] [COMMITTERS] pgsql: Basic documentation for ROLEs.

2005-07-30 Thread Alvaro Herrera
On Sat, Jul 30, 2005 at 12:19:41AM -0400, Bruce Momjian wrote: I have just loaded the patches list with all outstanding patches that need consideration, and updated the open items list: http://momjian.postgresql.org/cgi-bin/pgpatches

[HACKERS] Buildfarm's opsrey goes green...

2005-07-30 Thread RĂ©mi Zara
Hi, My buildfarm member opsrey has turned green, thanks to the following two things: * the removal of the contrib module tsearch (that was miscompiling) * the removal from my config of plperl and pltcl. My installations of perl and tcl link to pthread, and postgresql does not,

Re: [HACKERS] Chocked

2005-07-30 Thread Christopher Kings-Lynne
They usually claim to be the world's most POPULAR open source database... Chris ohp@pyrenet.fr wrote: Who copied? I've been to mysql site 2 mn ago (did'nt occur since at least 6 months) title says : Mysql: The world most advanced opensource database. Isn't it the title for postgresql? It

Re: [HACKERS] Chocked

2005-07-30 Thread Andreas Pflug
Christopher Kings-Lynne wrote: They usually claim to be the world's most POPULAR open source database... Zillions of flies can't be wrong :o) Regards, Andreas ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Win32 build broken by recent changes to xlog.c

2005-07-30 Thread Magnus Hagander
Seems it's dead on the buildfarm box as well: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=snakedt=2005-07-30%20 01:00:01 From what I can tell, the recent patch for O_DIRECT broke it. //Magnus ---(end of broadcast)--- TIP 2: Don't 'kill -9'

Re: [HACKERS] PL/Perl list value return causes segfault

2005-07-30 Thread Andrew Dunstan
David Fetter wrote: *** 716,724 listitem para ! In the current implementation, if you are fetching or returning ! very large data sets, you should be aware that these will all go ! into memory. /para /listitem /itemizedlist --- 766,776

Re: [HACKERS] Updated open items

2005-07-30 Thread Bruce Momjian
Andrew Dunstan wrote: Bruce, some of the items on your patches list don't seem to contain patches ... Right, some are open items, but the patches list is a central place to put everything. In particular, . the thread multibyte regression tests - If you like you can put a TODO on

Re: [HACKERS] Updated open items

2005-07-30 Thread Andrew Dunstan
Bruce, some of the items on your patches list don't seem to contain patches ... In particular, . the thread multibyte regression tests - If you like you can put a TODO on the list and put my name against it, but I won't be getting to it any time soon, and nobody else has done any work on

Re: [HACKERS] multibyte regression tests

2005-07-30 Thread Bruce Momjian
This has been saved for the 8.2 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Andrew Dunstan wrote: Luke Lonergan wrote: Andrew, Good. So should we roll this up into the

Re: [HACKERS] Updated open items

2005-07-30 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: . the thread windows regression failure - prepared xacts - in another thread here: http://archives.postgresql.org/pgsql-hackers/2005-07/msg00621.php Tom proposed a possible cause for the problem seen (race conditions in is_visible() and friends)

Re: [HACKERS] Updated open items

2005-07-30 Thread Bruce Momjian
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: . the thread windows regression failure - prepared xacts - in another thread here: http://archives.postgresql.org/pgsql-hackers/2005-07/msg00621.php Tom proposed a possible cause for the problem seen (race conditions in

Re: [HACKERS] [PATCHES] Interval-day docs and regression tests

2005-07-30 Thread Tom Lane
Michael Glaesemann [EMAIL PROTECTED] writes: Please find attached diffs for documentation and simple regression tests for the new interval-day changes. The buildfarm results suggest that justify_days is broken in the integer-datetimes case, eg from panda: *** ./expected/interval.out Sat

Re: [HACKERS] Write past chunk end?

2005-07-30 Thread Magnus Hagander
I'm testing out the latest version of Palles ICU patch on win32, and I got the build syste mworking. But it no longer works when built - it used to... When initdb:ing with this version and -E UNICODE, I get: WARNING: detected write past chunk end in Analyze Column 01472ED0

Re: [HACKERS] [COMMITTERS] pgsql: Add GUC variables to control keep-alive times for idle, interval,

2005-07-30 Thread Rocco Altier
This broke the build on AIX. AIX does not have SOL_TCP as a defined symbol in any of the system header files. -rocco -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: Saturday, July 30, 2005 11:17 AM To:

Re: [HACKERS] [COMMITTERS] pgsql: Add GUC variables to control keep-alive times

2005-07-30 Thread Bruce Momjian
Rocco Altier wrote: This broke the build on AIX. AIX does not have SOL_TCP as a defined symbol in any of the system header files. OK, is there any way of setting the keepalive values on AIX? -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us

Re: [HACKERS] [COMMITTERS] pgsql: Add GUC variables to control keep-alive

2005-07-30 Thread Andrew Dunstan
Bruce Momjian wrote: Rocco Altier wrote: This broke the build on AIX. AIX does not have SOL_TCP as a defined symbol in any of the system header files. OK, is there any way of setting the keepalive values on AIX? Looks like Unixware is broken too, cheers andrew

Re: [HACKERS] [COMMITTERS] pgsql: Add GUC variables to control keep-alive

2005-07-30 Thread Larry Rosenman
Andrew Dunstan wrote: Looks like Unixware is broken too, cheers andrew I think Tom's fix to use IPPROTO_TCP will fix firefly. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 3535 Gaspar

Re: [HACKERS] [COMMITTERS] pgsql: Add GUC variables to control keep-alive

2005-07-30 Thread Oliver Jowett
Larry Rosenman wrote: I think Tom's fix to use IPPROTO_TCP will fix firefly. Ah, I forgot about the we'll just use IP protocol numbers as socket option levels behaviour (BSD-derived?). My Linux man page only talks about SOL_TCP, but I have run into this before and should have remembered.. my

Re: [HACKERS] PL/Perl list value return causes segfault

2005-07-30 Thread David Fetter
On Sat, Jul 30, 2005 at 09:47:58AM -0400, Andrew Dunstan wrote: David Fetter wrote: You have rolled 2 problems into one - spi_query+spi_fetchrow does not address the issue of returning large data sets. Suggest instead: [suggestion] Revised patch attached. Thanks for catching this

Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

2005-07-30 Thread Denis Lussier
Title: Re: MySQL to PostgreSQL for SugarCRM Thanks, I'll check it out. I didn't see much evidence on the SugarCRM site that they are interested in an DB besides MySQL. But, it is also my hope that the core SugarCRM project will come around to supporting EDB/PostgreSQL (once we have done

Re: [HACKERS] [COMMITTERS] pgsql: Add GUC variables to control keep-alive

2005-07-30 Thread Larry Rosenman
Larry Rosenman wrote: I think Tom's fix to use IPPROTO_TCP will fix firefly. LER And based on the last run, it did. Thanks, Tom! -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 3535 Gaspar Drive,

[HACKERS] Remote administration functionality

2005-07-30 Thread Bruce Momjian
Let me try to outline where I think our goals are for remote administration. I will not comment on Dave's analysis of the patch review process, but I think he has some valid points that this patch was not treated properly. Basically, I think everyone wants remote administration. Remote

Re: [HACKERS] Remote administration functionality

2005-07-30 Thread Steve Atkins
On Sat, Jul 30, 2005 at 11:39:20PM -0400, Bruce Momjian wrote: Let me try to outline where I think our goals are for remote administration. I will not comment on Dave's analysis of the patch review process, but I think he has some valid points that this patch was not treated properly.

Re: [HACKERS] Remote administration functionality

2005-07-30 Thread Alvaro Herrera
On Sat, Jul 30, 2005 at 09:35:16PM -0700, Steve Atkins wrote: On Sat, Jul 30, 2005 at 11:39:20PM -0400, Bruce Momjian wrote: Let me try to outline where I think our goals are for remote administration. I will not comment on Dave's analysis of the patch review process, but I think he has