Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG or strange behaviour of update on primary key - Mailing list pgsql-hackers

From Robert Haas
Subject Re: BUG or strange behaviour of update on primary key
Date
Msg-id CA+TgmobZc3ESA2ffCrQi-kA0HL7d=CMEzO4K11Qtkq1Ngy_s6w@mail.gmail.com
Whole thread Raw
In response to Re: BUG or strange behaviour of update on primary key  (desmodemone <desmodemone@gmail.com>)
Responses Re: BUG or strange behaviour of update on primary key  (Royce Ausburn <royce.ml@inomial.com>)
Re: BUG or strange behaviour of update on primary key  (desmodemone <desmodemone@gmail.com>)
List pgsql-hackers
Tree view 
On Mon, Oct 17, 2011 at 7:30 PM, desmodemone <desmodemone@gmail.com> wrote:
> Seems an Oracle bug not Postgresql one!

I don't think it's a bug for it to work.  It'd probably work in
PostgreSQL too, if you inserted (2) first and then (1).  It's just
that, as Tom says, if you want it to be certain to work (rather than
depending on the order in which the rows are inserted), you need the
checks to be deferred.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: desmodemone
Date:
Subject: Re: BUG or strange behaviour of update on primary key
Next
From: Alvaro Herrera
Date:
Subject: Re: HeapTupleHeaderAdvanceLatestRemovedXid doing the wrong thing with multixacts