Re: Adding WHERE clause to pg_dump

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Adding WHERE clause to pg_dump
Дата
Msg-id 1217022994.3894.1049.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: Adding WHERE clause to pg_dump  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
On Fri, 2008-07-25 at 14:29 -0700, Joshua D. Drake wrote:
> 
> >  - users could make partial dumps and be confused and lose data.
> > 
> >       Yes, but they can already do that with -n, -t, and the new
> pre-data
> >       and post-data switches. This is one more case where the
> default is
> >       a full dump but you one can specificly request less.
> 
> No they actually can't. You are guaranteed that regardless of a -n or
> -t
> flag that the data you receive is consistent. You can't guarantee that
> with -w because you could pull different data based on an arbitrary
> conditional that can not apply to all objects.

But are you guaranteed that you have all tables in FK relationships? No.
(But I like that capability also - its useful).

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Adding WHERE clause to pg_dump
Следующее
От: Davy Durham
Дата:
Сообщение: Re: Adding WHERE clause to pg_dump