| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Greg Sabino Mullane <greg(at)turnstep(dot)com>, Hackers List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] Automatic transactions in psql |
| Date: | 2002-02-22 15:21:51 |
| Message-ID: | 3C76620F.C73CBE11@fourpalms.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
...
> > Secondly, it adds a "begin transaction" option that, when
> > enabled, ensures that you are always inside a transaction
> > while in psql, so you can always rollback. It does this
> > by issuing a BEGIN at the appropriate times. This patch
> > (if ever accepted) conflicts a bit with LO_RTANSACTION:
> > psql now *does* have a way to know if it is in a
> > transaction or not, so that part may need to get rewritten.
This part of the feature (corresponding to the Ingres "autocommit = off"
feature) should be implemented in the backend rather than in psql. I've
had a moderate interest in doing this but haven't gotten to it; if
someone wants to pick it up I'm sure it would be well received...
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-02-22 15:39:25 | Re: problem with restore of functions |
| Previous Message | Oleg Bartunov | 2002-02-22 15:20:14 | Re: problem with restore of functions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-02-22 16:09:48 | Re: [PATCHES] Automatic transactions in psql |
| Previous Message | Fernando Nasser | 2002-02-22 14:44:13 | Fix command completion for CREATE TABEL ... AS |