pg_dump and not MVCC-safe commands

Поиск
Список
Период
Сортировка
От PetSerAl
Тема pg_dump and not MVCC-safe commands
Дата
Msg-id CAKygsHQHhd4rzYcNCd8OJMH46saT1E+9+5MT2CgOCGgf_yaQAw@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump and not MVCC-safe commands
Список pgsql-general
How pg_dump interact with not MVCC-safe commands?

As I understand, pg_dump first take snapshot and then lock all tables
it intended to dump. What happens if not MVCC-safe command committed
after snapshot but before lock? From comment to pg_dump.c I understand
that it may fail with 'cache lookup failed' error. But, can it happen,
that pg_dump not fail, but instead capture inconsistent dump? For
example TRUNCATE committed after snapshot and pg_dump will see result
of TRUNCATE but not result of other commands in TRUNCATE transaction?



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

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Left join syntax error
Следующее
От: Rich Shepard
Дата:
Сообщение: Updating 457 rows in a table