Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group