pg_dump and not MVCC-safe commands - Mailing list pgsql-general

From PetSerAl
Subject pg_dump and not MVCC-safe commands
Date
Msg-id CAKygsHQHhd4rzYcNCd8OJMH46saT1E+9+5MT2CgOCGgf_yaQAw@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump and not MVCC-safe commands
List 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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Left join syntax error
Next
From: Rich Shepard
Date:
Subject: Updating 457 rows in a table