Re: [HACKERS] Re: Bug#43221: postgresql: When disk is full, insert corrupts indices - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] Re: Bug#43221: postgresql: When disk is full, insert corrupts indices
Date
Msg-id 37C12CBA.3B7F0319@krs.ru
Whole thread Raw
In response to Re: [HACKERS] Re: Bug#43221: postgresql: When disk is full, insert corrupts indices  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> Vadim Mikheev <vadim@krs.ru> writes:
> > Whenever index insert fails (for _any_ reason) index may be
>                                ^^^^^^^^^^^^^^^^
> > corrupted. I hope to address this with WAL...
> 
> One certainly hopes that's not true in the case of "cannot insert
> duplicate key into a unique index" failures !?

Oh, I meant cases when child btree page is splitted but
parent page is not updated, sorry.

BTW, duplicate check is made _before_ insertion...

Vadim
P.S. I'm on vacation till Aug 30...


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Tangent ... you know what's scary?
Next
From: Zakkr
Date:
Subject: trigger: run in transaction