Re: disable auto-commit - Mailing list pgsql-admin

From Alfred Perlstein
Subject Re: disable auto-commit
Date
Msg-id 20001026095313.J28123@fw.wintelcom.net
Whole thread Raw
In response to disable auto-commit  ("Joel Pang" <joelpang@spectratech.com>)
List pgsql-admin
* Joel Pang <joelpang@spectratech.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@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] pg_atoi: error in "template1": can't parse "template1"
Next
From: Ian Lance Taylor
Date:
Subject: Building in a different directory