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

Re: Transactions

From: Karla Peralta <karlaper(at)elrosado(dot)com>
To: Joel Burton <jburton(at)scw(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Transactions
Date: 2000-12-28 17:02:24
Message-ID: 3A4B7220.C000980A@elrosado.com (view raw or flat)
Thread:
Lists: pgsql-novice
Joel Burton wrote:

> > > > 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

How could I turn off the autotransaction if I use C and postgresql ???
And how do you do that with Perl ???

Karla


In response to

pgsql-novice by date

Next:From: John BurskiDate: 2000-12-29 15:36:07
Subject: date_part function
Previous:From: Thomas StepletonDate: 2000-12-27 23:38:11
Subject: newbie sql question re: subqueries, order by, and limit

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