pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Transactions and libpq 2+ messages / 2 participants [nested] [flat]
* Transactions and libpq @ 2006-08-21 23:11 osxdeveloper@mac.com 2006-08-21 23:28 ` Re: Transactions and libpq Michael Fuhr <mike@fuhr.org> 0 siblings, 1 reply; 2+ messages in thread From: osxdeveloper@mac.com @ 2006-08-21 23:11 UTC (permalink / raw) To: pgsql-interfaces Hi! I am writing an application using the libqpsql client lib. What I like to do now, is to control transaction behavior from within my application. But the following happens: When I try to open a transaction libpg prints "WARNING: there is already a transaction in progress" to stdout. The question for me is - why?? I searched Google and found some confusing things about serverside auto-commit - but this is removed at last in Postgres 8.0. Can somebody lighten my about the reason for this problem? Thanks for any help! Regards, Ralf Hasemann ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Transactions and libpq 2006-08-21 23:11 Transactions and libpq osxdeveloper@mac.com @ 2006-08-21 23:28 ` Michael Fuhr <mike@fuhr.org> 0 siblings, 0 replies; 2+ messages in thread From: Michael Fuhr @ 2006-08-21 23:28 UTC (permalink / raw) To: osxdeveloper@mac.com; +Cc: pgsql-interfaces On Tue, Aug 22, 2006 at 01:11:33AM +0200, osxdeveloper@mac.com wrote: > I am writing an application using the libqpsql client lib. Do you mean libpq? Are you coding in C? > What I like to do now, is to control transaction behavior > from within my application. > But the following happens: > When I try to open a transaction libpg prints > "WARNING: there is already a transaction in progress" > to stdout. > The question for me is - why?? As the error says: a transaction had already been started when the application tried to start another one. Can you post a simple but complete program that demonstrates this behavior when you think it shouldn't? You could also enable statement logging on the server to see everything the application is executing. > I searched Google and found some confusing things about serverside > auto-commit - but this is removed at last in Postgres 8.0. Server-side autocommit existed only in 7.3. What version of libpq are you using, and what version of the server? -- Michael Fuhr ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-08-21 23:28 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-08-21 23:11 Transactions and libpq osxdeveloper@mac.com 2006-08-21 23:28 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox