Guillaume Lelarge wrote: > Hi Andrew, > > Andrew Lazarus a écrit : >> Wednesday, October 3, 2007, 1:12:52 AM, you wrote: >> >> GL> [EMAIL PROTECTED] a écrit : >>>> to go with INSERT, DELETE, etc. >> GL> I don't see much interest in a TRUNCATE script because there's nothing >> GL> more to add on the script. How about a simple "Truncate" or "Empty >> GL> Table" menu in the contextual menu ? >> >> Works for me! (Maybe even two: TRUNCATE and TRUNCATE ... CASCADE) >> > > Here is the patch that adds a TRUNCATE and a TRUNCATE CASCADE menus. > They won't be in the 1.8 release but I hope it will be applied for the > next one.
Thanks Guillaume - I've applied this with the following tweaks: - Update the row count and refresh the properties list following the truncate. - Add a stronger warning to the 'Are you sure you want to continue' dialogue. Thanks, Dave ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match