Re: Performance question: Commit or rollback? - Mailing list pgsql-general

From Chris Angelico
Subject Re: Performance question: Commit or rollback?
Date
Msg-id CAPTjJmqSS9VZR6k=Hs+688p88OeNfS+XHxtCR2hY_MDmfN+KHw@mail.gmail.com
Whole thread Raw
In response to Re: Performance question: Commit or rollback?  (vinny <vinny@xs4all.nl>)
List pgsql-general
On Sun, Dec 25, 2011 at 12:00 AM, vinny <vinny@xs4all.nl> wrote:
> So, your read-only mode is basically a flag that forces your code to
> always issue a rollback at the end, instead of a commit for read/write
> mode.
>
> I find that a bit scary. :-)

It's three things:

1) BEGIN TRANSACTION READ ONLY instead of BEGIN TRANSACTION
2) A high level flag that tells the PHP code that it ought not to change things
3) ROLLBACK instead of COMMIT

ChrisA

pgsql-general by date:

Previous
From: vinny
Date:
Subject: Re: Performance question: Commit or rollback?
Next
From: Vincent Veyron
Date:
Subject: Re: PostgreSQL DBA in SPAAAAAAAACE