Re: Moving to postgresql and some ignorant questions

From: "Mikko Partio" <mpartio(at)gmail(dot)com>
To: "Bill Moran" <wmoran(at)potentialtech(dot)com>
Cc: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Moving to postgresql and some ignorant questions
Date: 2007-08-14 18:13:35
Message-ID: 2ca799770708141113o30871505y8cc01e98c08a8176@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/14/07, Bill Moran <wmoran(at)potentialtech(dot)com> wrote:

>
> But the rule is, if any query within the transaction errors, then all
> queries
> within the transaction are rolled back.

This is the default behaviour, but with psql and ON_ERROR_ROLLBACK parameter
the behaviour can be changed. See
http://www.postgresql.org/docs/8.2/interactive/app-psql.html

Regards

MP

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2007-08-14 18:13:40 Re: MVCC cons
Previous Message Thomas Kellerer 2007-08-14 18:09:45 Re: Moving to postgresql and some ignorant questions