Re: [BUGS] BUG #14874: Dublicate values in primary key

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14874: Dublicate values in primary key
Дата
Msg-id 5072.1509163017@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14874: Dublicate values in primary key  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: [BUGS] BUG #14874: Dublicate values in primary key
Список pgsql-bugs
Peter Geoghegan <pg@bowt.ie> writes:
> I agree with your conclusion, but I still think that it's slightly
> ambiguous. There didn't seem to be an issue with sequences going
> backwards -- the actual complaint was about there being multiple
> versions of the same logical row visible simultaneously (sequences
> were mentioned in passing). This is probably a case of tuples within a
> HOT chain experiencing some kind of "resurrection". Though that in
> itself doesn't prove much of anything.

Yeah, I wondered about that, particularly in view of the multiple
tuple-freezing bugs we've found.  If the damage were in just one table
I'd believe it for sure ... but I'm not sure I believe it across 5
tables.

But the bottom line is the same: update to 9.4.latest (which is *not*
12 btw), and double-check storage reliability.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [BUGS] BUG #14876: Segmentation fault with JSONB column used instore proc that gets used by view and later altered
Следующее
От: Arthur Zakirov
Дата:
Сообщение: Re: [BUGS] pg_trgm word_similarity inconsistencies or bug