Re: Rolling back transactions

uday@dpg.rnb.com (Uday Shankar) wrote: :Ok, thanks. I was wondering if there was a way around this, since :we typically do our testing in unlogged databases. I guess there :really isn't a way to roll back unlogged transactions then, but :I thought I'd ask anyway! In this case it might be usefull to turn on logging but use /dev/null as the tape device. In that case you have logging and can do begin/commit/rollback, but you can do no recovery of the logs. That may be usefull for testing purposes. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org