pg_dump --serializable-deferrable
The name of this new option is a bit of a mouthful, and it mixes in an
otherwise standardized term (deferrable, as in constraints) with
transaction isolation. Wouldn't something like --wait-for-serializable
be clearer (and shorter)?
Peter Eisentraut wrote:
The name of this new option is a bit of a mouthful, and it mixes in
an otherwise standardized term (deferrable, as in constraints) with
transaction isolation. Wouldn't something like
--wait-for-serializable be clearer (and shorter)?
I see it's not mentioned in the description of the pg_dump option,
but the option name is based on the new (PostgreSQL-specific)
DEFERRABLE transaction property which is used when the option is
specified.
See if it makes more sense after reading this page:
http://developer.postgresql.org/pgdocs/postgres/sql-set-transaction.html
Personally, I think DEFERRABLE is a good name for the transaction
property; it conveys the right semantics and avoids adding a new
reserved word. The question of what to name it was first raised
almost eight months ago, and it has been discussed many times since.
I'm less concerned about the pg_dump name, if you think something
else is clearer; although this one isn't the longest pg_dump option
we have.
-Kevin
Import Notes
Resolved by subject fallback