Re: Duplicated entries are not ignored even if a "do instead nothing" rule is added.

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: 邓尧 <torshie(at)gmail(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Duplicated entries are not ignored even if a "do instead nothing" rule is added.
Date: 2012-01-04 19:17:05
Message-ID: CA+mi_8bWuGo_PCZQY2X6-GpgmresEyQeD8JDsh8gy3ZBmtysyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 4, 2012 at 8:09 PM, Alban Hertroys <haramrae(at)gmail(dot)com> wrote:

> On 4 Jan 2012, at 3:03, 邓尧 wrote:

>> True, I don't need transactions, neither do I want them, but psycopg2 create transactions for me automatically :-(
>
> Well, if psycopg didn't, Postgres would wrap each statement in a transaction anyway. But that doesn't matter.

FYI, you can have psycopg in autocommit mode if you need that:
<http://initd.org/psycopg/docs/connection.html#connection.autocommit>.

-- Daniele

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Boettcher 2012-01-05 07:42:01 Re: help... lost database after upgrade from 9.0 to 9.1
Previous Message Alban Hertroys 2012-01-04 19:09:48 Re: Duplicated entries are not ignored even if a "do instead nothing" rule is added.