Re: unlogged tables
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Andy Colson <andy@squeakycode.net>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-11-16T22:22:35Z
Lists: pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes: > On Tue, Nov 16, 2010 at 3:50 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >> I think allowing pg_dump to dump the data in an unlogged table is not >> only reasonable, but essential. > Yeah, you'd have to allow a flag to control the behavior. And in that > case I'd rather the flag have a single default rather than different > defaults depending on whether or not individual tables were selected. > Something like --omit-unlogged-data. As long as the default is to include the data, I wouldn't object to having such a flag. A default that drops data seems way too foot-gun-like. regards, tom lane