Re: [HACKERS] Re: Bug#43221: postgresql: When disk is full, insert corrupts indices
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 !?
regards, tom lane
Import Notes
Reply to msg id not found: YourmessageofFri20Aug1999133705+080037BCE981.A457449B@krs.ru
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...