Re: How to test something using ROLLBACK TRANSACTION

On Thu, Sep 4, 2008 at 1:17 PM, William Garrison <postgres(at)mobydisk(dot)com> 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