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

From Tom Lane
Subject Re: "truncate all"?
Date
Msg-id 6986.1060013965@sss.pgh.pa.us
Whole thread Raw
In response to Re: "truncate all"?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: "truncate all"?
Re: "truncate all"?
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> This this a TODO?  Keep in mind if we follow the syntax of VACUUM and
> (7.4) CLUSTER, that the all-database truncate would just be "TRUNACATE".
> That seems very risky to me.  I wonder if the risk is worth adding this
> feature.

I wouldn't care for that either.  The prior suggestion of "TRUNCATE tab
CASCADE" (to truncate any tables with FK dependencies on the original
target, instead of failing) seems more reasonable.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: "truncate all"?
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: "truncate all"?