Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread Bruce Momjian
Tom Lane wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > Sorry, that should have been: > > Isn't it true that reindex's behavior ON A FAILURE is to simply, quietly > > delete the index? that was reported ^ > > No. > > If you are doing a standalone system index rebuild (wi

Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread Tom Lane
"scott.marlowe" <[EMAIL PROTECTED]> writes: > Sorry, that should have been: > Isn't it true that reindex's behavior ON A FAILURE is to simply, quietly > delete the index? that was reported ^ No. If you are doing a standalone system index rebuild (with backend -P switch) then REIND

Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread Bruce Momjian
I am not sure, but it certainly makes sense that it would drop the index on failure. I would never expect it to fail, however. --- scott.marlowe wrote: > Sorry, that should have been: > > Isn't it true that reindex's beha

Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread scott.marlowe
Sorry, that should have been: Isn't it true that reindex's behavior ON A FAILURE is to simply, quietly delete the index? that was reported ^ On Tue, 27 Aug 2002, Bruce Momjian wrote: > > REINDEX just rebuilds the index, not just drop it. In fact, 7.3 will > have a reindexdb sc

Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread Bruce Momjian
Alvaro Herrera wrote: > On Tue, 27 Aug 2002, Bruce Momjian wrote: > > > Christopher Kings-Lynne wrote: > > > Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands? > > > This would be neat. Plus, it means we don't have to worry about having > > > unix-only script in the dis

Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread Alvaro Herrera
On Tue, 27 Aug 2002, Bruce Momjian wrote: > Christopher Kings-Lynne wrote: > > Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands? > > This would be neat. Plus, it means we don't have to worry about having > > unix-only script in the distro once we have Win32 support. >

Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread Bruce Momjian
REINDEX just rebuilds the index, not just drop it. In fact, 7.3 will have a reindexdb script. --- scott.marlowe wrote: > On Tue, 27 Aug 2002, Bruce Momjian wrote: > > > Christopher Kings-Lynne wrote: > > > Would it be wor

Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread scott.marlowe
On Tue, 27 Aug 2002, Bruce Momjian wrote: > Christopher Kings-Lynne wrote: > > Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands? > > This would be neat. Plus, it means we don't have to worry about having > > unix-only script in the distro once we have Win32 support. >

Re: [HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread Bruce Momjian
Christopher Kings-Lynne wrote: > Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands? > This would be neat. Plus, it means we don't have to worry about having > unix-only script in the distro once we have Win32 support. > > Actually, we should just leave the 'ALL' off. T

[HACKERS] REINDEX ALL and CLUSTER ALL

2002-08-27 Thread Christopher Kings-Lynne
Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands? This would be neat. Plus, it means we don't have to worry about having unix-only script in the distro once we have Win32 support. Actually, we should just leave the 'ALL' off. That will make them behave like VACUUM wit