Re: [HACKERS] VACUUM DATABASE

2005-07-27 Thread Simon Riggs
On Wed, 2005-07-27 at 19:09 -0400, Alvaro Herrera wrote: > On Wed, Jul 27, 2005 at 11:41:24PM +0100, Simon Riggs wrote: > > > Forgive me if this is wrong, but I took that Alvaro was applying a > > "reductio ad absurdum" argument (i.e. taking the piss). I laughed > > heartily at the thought of LAZY

Re: [HACKERS] VACUUM DATABASE

2005-07-27 Thread Alvaro Herrera
On Wed, Jul 27, 2005 at 11:41:24PM +0100, Simon Riggs wrote: > Forgive me if this is wrong, but I took that Alvaro was applying a > "reductio ad absurdum" argument (i.e. taking the piss). I laughed > heartily at the thought of LAZY becoming a PostgreSQL keyword. Ah, well, actually you are wrong,

Re: [HACKERS] VACUUM DATABASE

2005-07-27 Thread Simon Riggs
On Wed, 2005-07-27 at 00:07 -0400, Robert Treat wrote: > On Tuesday 26 July 2005 16:53, Alvaro Herrera wrote: > > On Tue, Jul 26, 2005 at 09:30:20PM +0100, Simon Riggs wrote: > > > I'd like to suggest altering the syntax of VACUUM so that it is possible > > > to issue the command VACUUM DATABASE. T

Re: [HACKERS] VACUUM DATABASE

2005-07-27 Thread Robert Treat
On Tuesday 26 July 2005 16:53, Alvaro Herrera wrote: > On Tue, Jul 26, 2005 at 09:30:20PM +0100, Simon Riggs wrote: > > I'd like to suggest altering the syntax of VACUUM so that it is possible > > to issue the command VACUUM DATABASE. The keyword DATABASE would be > > optional, to allow backward co

Re: [HACKERS] VACUUM DATABASE

2005-07-26 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > I'd like to suggest altering the syntax of VACUUM so that it is possible > to issue the command VACUUM DATABASE. The keyword DATABASE would be > optional, to allow backward compatibility. This would require converting DATABASE from an unreserved keyword in

Re: [HACKERS] VACUUM DATABASE

2005-07-26 Thread Alvaro Herrera
On Tue, Jul 26, 2005 at 09:30:20PM +0100, Simon Riggs wrote: > > I'd like to suggest altering the syntax of VACUUM so that it is possible > to issue the command VACUUM DATABASE. The keyword DATABASE would be > optional, to allow backward compatibility. Huh, so why not have an optional LAZY? I un

[HACKERS] VACUUM DATABASE

2005-07-26 Thread Simon Riggs
I'd like to suggest altering the syntax of VACUUM so that it is possible to issue the command VACUUM DATABASE. The keyword DATABASE would be optional, to allow backward compatibility. The reasons for this are better understanding and comprehension. S many people are confused about the differe