Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-26 Thread Markus Schaber
Hi, Bruce, Bruce Momjian wrote: >>> Allow inheritance to be removed from tables >> I'd enhance that to "Allow table inheritance relationships to be defined >> for and removed from pre-existing tables." > > Good point. Updated wording: > > Allow table inheritance to be added and

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-26 Thread Bruce Momjian
Markus Schaber wrote: -- Start of PGP signed section. > Hi, Bruce, > > Bruce Momjian wrote: > > > > > > > Allow inheritance to be removed from tables > > > > > > I'd enhance that to "Allow table inheritance relationships to be defined > for and removed from

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-26 Thread Markus Schaber
Hi, Bruce, Bruce Momjian wrote: > > > Allow inheritance to be removed from tables > > I'd enhance that to "Allow table inheritance relationships to be defined for and removed from pre-existing tables." HTH, Markus -- Markus Schaber | Logical Tracking&Trac

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-26 Thread Bruce Momjian
Andrew Dunstan wrote: > Bruce Momjian wrote: > > I created a major features list for 8.2 and put it into CVS. Instead of > > going into detail (meaning the item would not appear in the "Changes" > > section below, I just highlighted some of the big stuff, and was > > purposely vague about the deta

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-25 Thread Andrew Sullivan
On Fri, Sep 22, 2006 at 12:59:36PM -0700, Joe Conway wrote: > > In that case, what about things on gborg too? Yes, same idea. I don't care where the project _lives_; the important thing is its integration with PostgreSQL (and its quality). A -- Andrew Sullivan | [EMAIL PROTECTED] When my inf

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-25 Thread Josh Berkus
Folks, On Thu, Sep 21, 2006 at 03:05:36PM -0500, Jim C. Nasby wrote: Regardless, I think we should include a section of major new projects/developments from pgFoundry, because they ultimately make PostgreSQL a more useful database. Maybe this list should only be in the I like that. "New enha

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-25 Thread Dave Page
> -Original Message- > From: David Fetter [mailto:[EMAIL PROTECTED] > Sent: 25 September 2006 16:57 > To: Dave Page > Cc: Jim C. Nasby; Joe Conway; Andrew Sullivan; > pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Release Notes: Major Changes in 8.2 > &

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-25 Thread David Fetter
On Mon, Sep 25, 2006 at 03:10:39PM +0100, Dave Page wrote: > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby > > > > For example, didn't pgAdmin just add support for Slony? That's > > something worth mentioning. > > That was our last major release. You can see w

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-25 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby > Sent: 25 September 2006 15:03 > To: Joe Conway > Cc: Andrew Sullivan; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Release Notes: Major Changes in 8

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-25 Thread Jim C. Nasby
On Fri, Sep 22, 2006 at 12:59:36PM -0700, Joe Conway wrote: > Andrew Sullivan wrote: > >On Thu, Sep 21, 2006 at 03:05:36PM -0500, Jim C. Nasby wrote: > > > >>Regardless, I think we should include a section of major new > >>projects/developments from pgFoundry, because they ultimately make > >>Postg

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-22 Thread Joe Conway
Andrew Sullivan wrote: On Thu, Sep 21, 2006 at 03:05:36PM -0500, Jim C. Nasby wrote: Regardless, I think we should include a section of major new projects/developments from pgFoundry, because they ultimately make PostgreSQL a more useful database. Maybe this list should only be in the I like

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-22 Thread Andrew Dunstan
Bruce Momjian wrote: I created a major features list for 8.2 and put it into CVS. Instead of going into detail (meaning the item would not appear in the "Changes" section below, I just highlighted some of the big stuff, and was purposely vague about the details, so people just have an overview o

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-22 Thread Andrew Sullivan
On Thu, Sep 21, 2006 at 03:05:36PM -0500, Jim C. Nasby wrote: > Regardless, I think we should include a section of major new > projects/developments from pgFoundry, because they ultimately make > PostgreSQL a more useful database. Maybe this list should only be in the I like that. "New enhancemen

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-22 Thread Bruce Momjian
Great, all added. --- Simon Riggs wrote: > On Thu, 2006-09-21 at 21:45 -0400, Bruce Momjian wrote: > > > Let me know how it looks. > > Very Good > > > > Very last, Minor change thoughts: > > * Continuous

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-22 Thread Simon Riggs
On Thu, 2006-09-21 at 21:45 -0400, Bruce Momjian wrote: > Let me know how it looks. Very Good Very last, Minor change thoughts: * Continuous archiving enhancements change: Warm Standby enhancements The improvements to Continuous Archiving relat

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Bruce Momjian
I created a major features list for 8.2 and put it into CVS. Instead of going into detail (meaning the item would not appear in the "Changes" section below, I just highlighted some of the big stuff, and was purposely vague about the details, so people just have an overview of what is below. Let

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Karen Hill
Simon Riggs wrote: > > SQL:2003 Analytical functions (Sergey, Tom, Neil) > > All statistical aggregate functions defined by SQL:2003 are now > supported and user-defined aggregates now can take multiple columns as > inputs. > Could this be a good starting point for SQL:2003 Window functions

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Chris Browne
[EMAIL PROTECTED] (Bruce Momjian) writes: > Josh Berkus wrote: >> Bruce, >> >> What happened to PL/pgSQL debugging? Did it die? > > The debuggers is going to be on pgfoundry, if it isn't there already. > The idea is that it would be loadable for 8.2, work out all the bugs, > and perhaps included

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Bruce Momjian
Josh Berkus wrote: > Bruce, All: > > > The debuggers is going to be on pgfoundry, if it isn't there already. > > The idea is that it would be loadable for 8.2, work out all the bugs, > > and perhaps included in 8.3. > > > > So, should I take this off the press list for 8.2 and save it for 8.3,

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Jim C. Nasby
On Thu, Sep 21, 2006 at 11:24:53AM -0400, Bruce Momjian wrote: > Josh Berkus wrote: > > Bruce, > > > > What happened to PL/pgSQL debugging? Did it die? > > The debuggers is going to be on pgfoundry, if it isn't there already. > The idea is that it would be loadable for 8.2, work out all the bug

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Josh Berkus
Bruce, All: The debuggers is going to be on pgfoundry, if it isn't there already. The idea is that it would be loadable for 8.2, work out all the bugs, and perhaps included in 8.3. So, should I take this off the press list for 8.2 and save it for 8.3, when the feature will be actually usefu

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian > Sent: 21 September 2006 16:25 > To: Josh Berkus > Cc: pgsql-hackers@postgresql.org; Simon Riggs > Subject: Re: [HACKERS] Release Notes: Major Changes in 8.2 &

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Bruce Momjian
OK, I will work it. --- Simon Riggs wrote: > On Wed, 2006-09-20 at 23:22 -0400, Bruce Momjian wrote: > > > Usually the major items just jump out of the release list. In this > > case, nothing really jumped out, and I felt

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Bruce Momjian
Josh Berkus wrote: > Bruce, > > What happened to PL/pgSQL debugging? Did it die? The debuggers is going to be on pgfoundry, if it isn't there already. The idea is that it would be loadable for 8.2, work out all the bugs, and perhaps included in 8.3. -- Bruce Momjian [EMAIL PROTECTED] En

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-21 Thread Simon Riggs
On Wed, 2006-09-20 at 23:22 -0400, Bruce Momjian wrote: > Usually the major items just jump out of the release list. In this > case, nothing really jumped out, and I felt if I listed sereral, it was > going to look weak because they were not big things, so I figured I > would just go with the "br

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Zdenek Kotala
Simon Riggs napsal(a): Improved monitoring and performance tuning (Tom, Bruce, Greg, Larry) Overhead of statistics collection has been considerably reduced and new statistics and system information is available. Better query logging improves diagnostics and especially performance tunin

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Josh Berkus
Bruce, What happened to PL/pgSQL debugging? Did it die? -- Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Bruce Momjian
Usually the major items just jump out of the release list. In this case, nothing really jumped out, and I felt if I listed sereral, it was going to look weak because they were not big things, so I figured I would just go with the "broad" list. The criteria I usually use are things that were not

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Joshua D. Drake
Gregory Stark wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: No. 8.1 did not have it turned on by default. Neither does 8.2 though. oh... heh. J -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Pro

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Alvaro Herrera
Simon Riggs wrote: > On Wed, 2006-09-20 at 18:22 +0200, Andreas Pflug wrote: > > Simon Riggs wrote: > > > Zero administration overhead now possible (Alvaro) > > > > > > With autovacuum enabled, all required vacuuming will now take place > > > without administrator intervention enabling wider dist

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Gregory Stark
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > No. 8.1 did not have it turned on by default. Neither does 8.2 though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 6: explain analyze is your

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Simon Riggs
On Wed, 2006-09-20 at 18:22 +0200, Andreas Pflug wrote: > Simon Riggs wrote: > > Zero administration overhead now possible (Alvaro) > > > > With autovacuum enabled, all required vacuuming will now take place > > without administrator intervention enabling wider distribution of > > embedded data

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Joshua D. Drake
Andreas Pflug wrote: Simon Riggs wrote: Zero administration overhead now possible (Alvaro) With autovacuum enabled, all required vacuuming will now take place without administrator intervention enabling wider distribution of embedded databases. This was true for 8.1 already, no? N

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Andreas Pflug
Simon Riggs wrote: > Zero administration overhead now possible (Alvaro) > > With autovacuum enabled, all required vacuuming will now take place > without administrator intervention enabling wider distribution of > embedded databases. > This was true for 8.1 already, no? Regards, Andreas

[HACKERS] Release Notes: Major Changes in 8.2

2006-09-20 Thread Simon Riggs
I'd like to include a section on Major changes in this release at the top of the release notes, as has been done for at least the last 6 major releases. The notes below are one stab at that, for **discussion**. I've tried to arrange specific changes into groups... Major changes in this release: