| From: | Bricklen <bricklen-rem(at)yahoo(dot)comz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | autocommit to off? |
| Date: | 2004-03-03 15:51:16 |
| Message-ID: | U9n1c.55595$A12.16186@edtnps84 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I've scoured the net for a simple way to set AUTOCOMMIT off in psql, for
the duration of a session (not simply a transaction). The only real
reference that I can find says that "\set autocommit off" will do what I
want. It doesn't though. For example, if session A inserts a row, then
session B has access to that data immediately (from another terminal).
I realize that you can fire off a begin/end pair for every statement,
but I'm looking for something more global.
Oracle's SQL*Plus is what I'm used to, which is the reason that I'm asking.
Feel free to correct any (mis)understandings I have of psql.
Cheers,
Bricklen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron St-Pierre | 2004-03-03 15:55:36 | Re: Setting up Postgresql on Linux |
| Previous Message | Tom Lane | 2004-03-03 15:49:19 | Re: [ANNOUNCE] PostgreSQL 7.3.6 Now Available ... |