Re: pg_dump --serializable-deferrable

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <peter_e(at)gmx(dot)net>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump --serializable-deferrable
Date: 2011-05-11 06:24:03
Message-ID: 4DC9E533020000250003D540@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

http://search.postgresql.org/search?q=kevin+serializable+deferrable&m=1&l=1&d=365&s=d

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2011-05-11 07:17:37 Re: the big picture for index-only scans
Previous Message Fujii Masao 2011-05-11 05:29:48 Re: time-delayed standbys