Skip site navigation (1) Skip section navigation (2)

Re: Transactions

From: Joel Burton <jburton(at)scw(dot)org>
To: Karla Peralta <karlaper(at)elrosado(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Transactions
Date: 2000-12-21 23:43:37
Message-ID: Pine.LNX.4.21.0012211840520.1042-100000@olympus.scw.org (view raw or flat)
Thread:
Lists: pgsql-novice
> > > When I use the Begin and Commit in the program I get these :
> > >
> > > Notice: Begin: Already a transaction in progress
> > >
> > > Notice: Commit: no transaction in progress
> > >
> > > If I delete these options it works ok, but I want to manage the
> > > transactions.
> > >
> > > What can I do ???
> >
> > Karla --
> >
> > Are you trying this in psql, or through another inferface (perl, ODBC,
> > etc.)

> I have a program in Clipper, the compiler is FlagShip, and I access the
> database postgresql with SQLkit_pg (a tool of FlagShip). My OS is RedHat
> 6.2

I haven't used Clipper in a few years, and that was a DOS-only experience,
but, as a general sense, I'd suspect that Clipper (or SQLkit_pg) is
setting you up in AutoCommit mode (or whatever their version of this
term is). That is, they'll try to wrap each command of yours in its own
Begin/Commit command.

(With Perl's standard database software, DBI, it can make this assumption
as well, but you can set AutoCommit to off to handle your own
transactions.)

Unless you get some specific help here, you might want to pose the
question to newsgroups for your development environment about how to turn
off this feature, if this is in fact what it is.

Good luck!
-- 
Joel Burton   <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2000-12-22 01:30:31
Subject: Re: error "11"
Previous:From: David MerrillDate: 2000-12-21 22:30:16
Subject: error "11"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group