Re: [HACKERS] Interactive docs idea

2005-04-13 Thread Christopher Kings-Lynne
It seems that's not much of a danger -- the interactive Postgres documentation hardly gets any comments at all in the first place. It would be a big improvement if there were some way to encourage many more comments. Only link to the version with comments. Chris ---(end of b

Re: [HACKERS] Interactive docs idea

2005-04-13 Thread Greg Stark
Alvaro Herrera <[EMAIL PROTECTED]> writes: > I think it's an interesting idea to mail the comments to pgsql-docs, but > *please don't* start emulating the PHP behavior regarding comments > (leaving the "relevant" ones forever) :-( I think the PHP manuals are > very low quality because of the info

Re: [HACKERS] Regression failures on freebsd

2005-04-13 Thread Michael Fuhr
On Thu, Apr 14, 2005 at 09:52:11AM +0800, Christopher Kings-Lynne wrote: > > I did 'gmake distclean' and rebuild and I still get the attached failures. What versions of PostgreSQL and FreeBSD? The FreeBSD machines in the buildfarm look good. http://www.pgbuildfarm.org/cgi-bin/show_status.pl If

Re: [HACKERS] Regression failures on freebsd

2005-04-13 Thread Christopher Kings-Lynne
Do you build in a separate directory? I do and I do have problems when the grammars (main or plpgsql) get updated -- not sure why the derived files from bison and flex don't get rebuilt. I just delete them by hand. (The build directory I just rm -fr as a whole). Yours doesn't seem like a problem

Re: [HACKERS] Regression failures on freebsd

2005-04-13 Thread Alvaro Herrera
On Thu, Apr 14, 2005 at 09:52:11AM +0800, Christopher Kings-Lynne wrote: > I did 'gmake distclean' and rebuild and I still get the attached failures. Do you build in a separate directory? I do and I do have problems when the grammars (main or plpgsql) get updated -- not sure why the derived files

Re: [HACKERS] Interactive docs idea

2005-04-13 Thread Alvaro Herrera
On Thu, Apr 14, 2005 at 09:41:43AM +0800, Christopher Kings-Lynne wrote: > After working on PHP for a few weeks, I see that what they do with their > interactive docs is have any comments posted get emailed to the docs > list. Do we do this? I think it's an interesting idea to mail the comment

[HACKERS] Regression failures on freebsd

2005-04-13 Thread Christopher Kings-Lynne
I did 'gmake distclean' and rebuild and I still get the attached failures. Chris parallel group (13 tests): text name char varchar boolean oid int8 int2 float4 int4 float8 bit numeric boolean ... ok char ... ok name ... ok varchar

[HACKERS] Interactive docs idea

2005-04-13 Thread Christopher Kings-Lynne
Hi guys, After working on PHP for a few weeks, I see that what they do with their interactive docs is have any comments posted get emailed to the docs list. Do we do this? That was, good comments are immediately integrated into the manual. Chris ---(end of broadcast)

Re: [HACKERS] [PERFORM] Compressing WAL

2005-04-13 Thread Simon Riggs
On Sun, 2005-04-10 at 21:12 -0400, Bruce Momjian wrote: > Jim C. Nasby wrote: > > Maybe better for -hackers, but here it goes anyway... > > > > Has anyone looked at compressing WAL's before writing to disk? On a > > system generating a lot of WAL it seems there might be some gains to be > > had WA

Re: [HACKERS] PLM pulling from CVS nightly for testing in STP

2005-04-13 Thread Mark Wong
w are you nameing these? The naming convention I'm using is postgresql-MMDD, for example postgresql-20050413, for the anonymous cvs export from today (April 13). I have a cronjob that'll do the export at 1AM PST8PDT. The search page for the PLM numbers is here: https://www

Re: [HACKERS] System vs non-system casts

2005-04-13 Thread Jim C. Nasby
On Tue, Apr 12, 2005 at 01:04:20PM -0400, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > What about the simple one of having a bool "pg_cast.castissystem" > > column, or something similar? > > This one is sounding pretty good to me, though I'd be inclined to call > it "castisbuil

Re: [HACKERS] PLM pulling from CVS nightly for testing in STP

2005-04-13 Thread Josh Berkus
Mark, > Just wanted everyone to know what we're pulling CVS HEAD nightly so it > can be tested in STP now. Let me know if you have any questions. Way cool.How do I find the PLM number? How are you nameing these? -- --Josh Josh Berkus Aglio Database Solutions San Francisco -

[HACKERS] PLM pulling from CVS nightly for testing in STP

2005-04-13 Thread Mark Wong
Hi all, Just wanted everyone to know what we're pulling CVS HEAD nightly so it can be tested in STP now. Let me know if you have any questions. Tests are not automatically run yet, but I hope to remedy that shortly. For those not familiar with STP and PLM, here are a couple of links: STP

Re: [HACKERS] Test coverage for external sorting

2005-04-13 Thread Josh Berkus
Tom, > BTW, as for your original question about performance, the current > external sort algorithm is mainly designed to conserve disk space, > not to be as fast as possible. ÂIt could probably be a good bit faster > if we didn't mind taking twice as much space (mainly because the > physical disk

Re: [HACKERS] OUT parameters in PL/Java

2005-04-13 Thread Thomas Hallgren
Tom Lane wrote: Thomas Hallgren <[EMAIL PROTECTED]> writes: thhal=# create function javatest.recordExample(int, int) returns record as 'org.postgresql.pljava.example.ComplexReturn.complexReturn' immutable language java; CREATE FUNCTION thhal=# select * from javatest.recordExample(3, 4) as (foo

Re: [HACKERS] OUT parameters in PL/Java

2005-04-13 Thread Tom Lane
Thomas Hallgren <[EMAIL PROTECTED]> writes: > thhal=# create function javatest.recordExample(int, int) returns record > as 'org.postgresql.pljava.example.ComplexReturn.complexReturn' immutable > language java; > CREATE FUNCTION > thhal=# select * from javatest.recordExample(3, 4) as (foo int, bar