Re: [Q] rollback after select?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: V S P <toreason(at)fastmail(dot)fm>
Cc: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [Q] rollback after select?
Date: 2009-03-30 08:27:42
Message-ID: 20090330082742.GA29110@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2009-03-30 08:34:31 Re: New shapshot RPMs (Mar 27, 2009) are ready for testing
Previous Message Ow Mun Heng 2009-03-30 08:08:34 Re: Parallel DB architechture