Re: [GENERAL] DROP TABLESPACE fails

2006-08-08 Thread Michael Fuhr
On Tue, Aug 08, 2006 at 11:25:23AM -0500, Steve Peterson wrote: > Note that if needed I can whack the database and start over very > easily, if that's the most expedient way out of this. That might be the easiest thing to do, but it might also be worth investigating what happened. It's possible

Re: [GENERAL] DROP TABLESPACE fails

2006-08-08 Thread Steve Peterson
At 07:06 PM 8/7/2006, Michael Fuhr wrote: On Mon, Aug 07, 2006 at 05:36:49PM -0500, Steve Peterson wrote: > I'm doing some tests with version 8.1.4 on Windows XP and am having > trouble recovering some disk space. > > The tests involve loading some largeish CSV files in via COPY. One > of the CO

Re: [GENERAL] DROP TABLESPACE fails

2006-08-07 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Mon, Aug 07, 2006 at 05:36:49PM -0500, Steve Peterson wrote: >> DROP TABLESPACE x returns 'tablespace "x" is not empty', but if I >> examine the 'referenced by' tab in pgAdmin nothing is listed. The >> tablespace directory contains several very large

Re: [GENERAL] DROP TABLESPACE fails

2006-08-07 Thread Michael Fuhr
On Mon, Aug 07, 2006 at 05:36:49PM -0500, Steve Peterson wrote: > I'm doing some tests with version 8.1.4 on Windows XP and am having > trouble recovering some disk space. > > The tests involve loading some largeish CSV files in via COPY. One > of the COPY commands failed and I'm trying to reco

[GENERAL] DROP TABLESPACE fails

2006-08-07 Thread Steve Peterson
I'm doing some tests with version 8.1.4 on Windows XP and am having trouble recovering some disk space. The tests involve loading some largeish CSV files in via COPY. One of the COPY commands failed and I'm trying to recover the disk space without having to completely reinitialize things. D