| From: | Vitaly Belman <vitalyb(at)gmail(dot)com> |
|---|---|
| To: | Olivier Thauvin <olivier(dot)thauvin(at)aerov(dot)jussieu(dot)fr> |
| Cc: | Postgresql Novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Autocommit in Postgresql |
| Date: | 2005-05-12 13:26:37 |
| Message-ID: | fa96e3c605051206265cb3b21c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-novice |
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.
On 5/12/05, Olivier Thauvin <olivier(dot)thauvin(at)aerov(dot)jussieu(dot)fr> wrote:
> Le Thursday 12 May 2005 09:31, Vitaly Belman a écrit :
> > I read that the "autocommit" setting doesn't exist in the new versions
> > of PostgreSQL. Is there another way to do it? I am using pgAdmin and
> > it is quite annoying to remember to open a transaction everytime.
>
> The autocommit setting is the default except you explicitly open a
> transaction.
>
>
>
--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent(at)hotmail(dot)com
Yahoo!: VitalyBe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-05-12 14:43:00 | Re: Autocommit in Postgresql |
| Previous Message | Olivier Thauvin | 2005-05-12 08:14:56 | Re: Autocommit in Postgresql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vyom A | 2005-05-12 13:42:54 | Starting the Database |
| Previous Message | Steve Tucknott | 2005-05-12 10:56:19 | Trigger Procedures |