On Thu, Sep 4, 2008 at 1:17 PM, William Garrison <postgres@xxxxxxxxxxxx> wrote: > Coming from MS SQL server, if I ever change anything vital on a production > system, or do any kind of major hackery on my own, I wrap it in a > transaction first: > > BEGIN TRANSACTION; > DELETE FROM vital_information WHERE primary_key = 10; > ROLLBACK TRANSACTION; > > I then make sure that the result comes back and says > 1 row(s) modified > or something equally reassuring. I have horror stories where DBAs > fat-fingered something and deleted data. But when I do this in pgadmin3, I > get a dissatisfying result: Have you tried psql? That's all I usually use. Here's what I get from inside psql: smarlowe=# begin; BEGIN smarlowe=# delete from test where i between 4 and 6; DELETE 3 smarlowe=# rollback; ROLLBACK
