Re: database auto-commit

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: "FERREIRA, William (COFRAMI)" <William(dot)FERREIRA(at)airbus(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: database auto-commit
Date: 2005-06-09 16:05:02
Message-ID: 20050609160502.GL44623@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

IIRC there is no autocommit in postgresql itself, so the autocommit is
probably from whatever connection library/method you're using. Note that
PSQL does have an autocommit option, but I don't see how that would
affect this case.

On Tue, May 31, 2005 at 03:12:26PM +0200, FERREIRA, William (COFRAMI) wrote:
>
> hi
>
> i writing a j2ee application working with postgresql and i meet a problem with autocommit
> from my j2ee application i call a perl function and i get an error :
> in french : Les Large Objects ne devraient pas ?tre utilis?s en mode auto-commit.
> in english : Large Objects should not be used in mode auto-committed.
>
> and i didn't find how to disable autocommit.
>
> Thanks in advance
>
> William
>
> This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this in mind if you answer this message.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-09 16:24:19 Re: Propogating conditions into a query
Previous Message Matt Miller 2005-06-09 16:02:56 Re: "returning" in postgresql request