Re: "truncate all"? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "truncate all"?
Date
Msg-id 8824.1061095326@sss.pgh.pa.us
Whole thread Raw
In response to Re: "truncate all"?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: "truncate all"?
List pgsql-hackers
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Sun, 17 Aug 2003, Bruce Momjian wrote:
>> Is this a bug?

> I don't think so.  I'd say this is the expected behavior. Part of the
> point is that it fails without checking for matching rows.

To do anything else, you'd have to solve some locking and/or
race-condition problems: rows could be inserted in the other table
while the TRUNCATE runs.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: "truncate all"?
Next
From: Joe Conway
Date:
Subject: char() datatype looses strings of all spaces