Re: pg_dump does not include triggers - should it?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump does not include triggers - should it?
Дата
Msg-id 24063.1321487125@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump does not include triggers - should it?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Список pgsql-general
Aleksey Tsalolikhin <atsaloli.tech@gmail.com> writes:
>   We just noticed our pg_dumps (generated with
> "pg_dump -Fc -n public $our_db_name") does not
> include triggers on tables in database $our_db_name.

-n restricts the dump to objects in the named schema.  It's impossible
to evaluate whether there is an issue here, since you have not told us
whether the trigger functions or the tables you are wondering about
are in that schema.  In general, though, you should expect that
restricting the dump leads to an incomplete dump ...

            regards, tom lane

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

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: insert locking issue for PG 9.0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How could I find the last modified procedure in the database?