On Mon, 2003-08-04 at 10:28, Rod Taylor wrote: > > Truncate isn't transaction safe either, so that shouldn't be a > problem. > > Actually, it is in 7.4
yeah i know, but I assumed he wasn't doing his production unit testing against 7.4. Course if he is all the better I suppose... :-) > > > Proper syntax for his feature would seem like: > > truncate table [cascade|restrict] ? > > Agreed. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster