Re: Serializable access giving wrong error messages?

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Mikko Vierula <mikko(dot)vierula(at)elektroniikkatyo(dot)fi>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Serializable access giving wrong error messages?
Date: 2001-12-28 04:13:50
Message-ID: 3C2BF17E.1E9DC644@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
>
> Sure, but what we were discussing was the "duplicate key" error issued
> by nbtinsert.c. AFAICS that depends on latest-commit status, not on
> snapshots. Perhaps that behavior is itself a bug? If so, how would
> you change it?

Addtional check seems to be needed in serializable
mode using the serialzable shot though I'm not sure.

currenly dead but was alive when the transaction begin
curretly alive but didin't exist when ...

etc may cause a "can't serialize ..." error.

regards,
Hiroshi Inoue

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-12-28 16:23:59 Bug #545: Keyword USER not detected in CREATE VIEW
Previous Message Tom Lane 2001-12-28 03:04:38 Re: Serializable access giving wrong error messages?