Re: [GENERAL] How to test something using ROLLBACK TRANSACTION

2008-09-04 Thread Richard Broersma
On Thu, Sep 4, 2008 at 12:28 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > Have you tried psql? That's all I usually use. Here's what I get The only problem with psql is that it is addictive. Once your hooked, it is hard to use anything else. :o) -- Regards, Richard Broersma Jr. Visit the

Re: [GENERAL] How to test something using ROLLBACK TRANSACTION

2008-09-04 Thread Scott Marlowe
On Thu, Sep 4, 2008 at 1:17 PM, William Garrison <[EMAIL PROTECTED]> 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 WH

[GENERAL] How to test something using ROLLBACK TRANSACTION

2008-09-04 Thread William Garrison
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