Re: disable auto-commit

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Joel Pang <joelpang(at)spectratech(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: disable auto-commit
Date: 2000-10-26 16:53:13
Message-ID: 20001026095313.J28123@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* Joel Pang <joelpang(at)spectratech(dot)com> [001026 04:27] wrote:
> In psql, once I delete an entry, it's gone permanently. How do I disable
> such auto-commit behavior?

by beginning a transaction, just type:

"BEGIN;"

then with 'COMMIT;' (to commit) or 'ROLLBACK' (to rollback).

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Lance Taylor 2000-10-26 18:19:03 Building in a different directory
Previous Message Oliver Elphick 2000-10-26 16:42:44 Re: pg_user, changing priviliges