| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Vitaly Belman <vitalyb(at)gmail(dot)com> |
| Cc: | Olivier Thauvin <olivier(dot)thauvin(at)aerov(dot)jussieu(dot)fr>, Postgresql Novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Autocommit in Postgresql |
| Date: | 2005-05-12 14:43:00 |
| Message-ID: | 572.1115908980@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-novice |
Vitaly Belman <vitalyb(at)gmail(dot)com> writes:
> That's the problem... Is there a way to make it implicitly open a
> transaction? For example now in pgAdmin when I play with SQLs I have
> to do begin and rollback constant because whenever a query fails it
> refuses to do anything at all until I "rollback", and then of course I
> have to do "begin" again unless I want my queries to be real.
pgAdmin really should offer some kind of setting to help you with that.
Try asking the pgadmin gurus (I am not sure if any of them read this
list).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vitaly Belman | 2005-05-12 14:46:35 | Fwd: [NOVICE] Autocommit in Postgresql |
| Previous Message | Vitaly Belman | 2005-05-12 13:26:37 | Re: Autocommit in Postgresql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vitaly Belman | 2005-05-12 14:46:35 | Fwd: [NOVICE] Autocommit in Postgresql |
| Previous Message | Vyom A | 2005-05-12 13:42:54 | Starting the Database |