Re: [Q] rollback after select? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: [Q] rollback after select?
Date
Msg-id 20090330082742.GA29110@svana.org
Whole thread Raw
In response to Re: [Q] rollback after select?  ("V S P" <toreason@fastmail.fm>)
List pgsql-general
On Sun, Mar 29, 2009 at 08:44:59PM -0400, V S P wrote:
> The same problem was with my set client encoding (my other email)
> both were related problem to the fact that PG I have to issue commits
> even for the 'non sql' statements.

That's something between you and your database driver. PostgreSQL by
default commits between each statement unless you explicitly start a
transaction.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: New shapshot RPMs (Mar 27, 2009) are ready for testing
Next
From: "Ow Mun Heng"
Date:
Subject: Re: Parallel DB architechture