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

From Josh Berkus
Subject Re: "truncate all"?
Date
Msg-id 200308040942.03024.josh@agliodbs.com
Whole thread Raw
In response to Re: "truncate all"?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "truncate all"?
List pgsql-hackers
Guys,

> 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.

I agree with Tom ... even the idea of a "TRUNCATE ALL" makes me nervous.  If 
we had such a feature, I'd advocate that it be superuser only.

As for "TRUNCATE CASCADE" or similar improvements, I agree that they could be 
convenient ... but are easily worked around currently.   So I wouldn't object 
to putting TRUNCATE CASCADE on the todo list, but would argue that it be left 
to the people who asked for it to implement it.

As far as 

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Thread-safe configuration option appears to
Next
From: Lee Kindness
Date:
Subject: Re: 7.4 COPY BINARY Format Change