Re: Remove sort files

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>>> One reasonable idea is
>>> cd pg_sorttemp ; rm -f *
>
>> OK, here is the new 'find' line:
>
> No, the point is not to use find at all.

Suppose I'm creating temporary files to sort, on the supported
platforms (anything non-windows AFAIK) can't you just create and
unlink the file so long as you don't close it?

-Michael
_________________________________________________________________
http://fastmail.ca/ - Fast Free Web Email for Canadians
>From pgsql-patches-owner(at)postgresql(dot)org Wed May 23 14:17:20 2001
Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46])
by postgresql.org (8.11.3/8.11.1) with ESMTP id f4NHrBA88002
for <pgsql-patches(at)postgresql(dot)org>; Wed, 23 May 2001 13:53:11 -0400 (EDT)
(envelope-from pgman(at)candle(dot)pha(dot)pa(dot)us)
Received: (from pgman(at)localhost)
by candle.pha.pa.us (8.10.1/8.10.1) id f4NHqrs21595;
Wed, 23 May 2001 13:52:53 -0400 (EDT)
From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Message-Id: <200105231752(dot)f4NHqrs21595(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: Remove sort files
In-Reply-To: <15958(dot)990639731(at)sss(dot)pgh(dot)pa(dot)us> "from Tom Lane at May 23, 2001 01:42:11
pm"
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Date: Wed, 23 May 2001 13:52:53 -0400 (EDT)
CC: Peter Eisentraut <peter_e(at)gmx(dot)net>,
PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
X-Mailer: ELM [version 2.4ME+ PL90 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Archive-Number: 200105/171
X-Sequence-Number: 820

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> One reasonable idea is
> >> cd pg_sorttemp ; rm -f *
>
> > OK, here is the new 'find' line:
>
> No, the point is not to use find at all.

Actually, I can do:

rm -f */pg_sorttemp/*

New command is:

snprintf(clear_pg_sorttemp, sizeof(clear_pg_sorttemp),
"rm -f \"%s\"/base/*/pg_sorttemp/*",
DataDir);

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026