Re: Help! Database restored with disabled triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Help! Database restored with disabled triggers
Дата
Msg-id 1703.1253719461@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Help! Database restored with disabled triggers  (Joe Kramer <cckramer@gmail.com>)
Список pgsql-general
Joe Kramer <cckramer@gmail.com> writes:
> On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver <aklaver@comcast.net> wrote:
>> What version of Postgres are you dumping from, restoring to? Which version of

> I am using client 8.1.9 to dump from server 8.3.0  (unable to use client 8.3.x)
> Importing to server 8.3.7.

You mean you are dumping from an 8.3 server with an 8.1 pg_dump?
That is pretty much guaranteed not to work; I am surprised that the
only symptom you notice is bad trigger state.  Why do you feel
you can't use an up-to-date pg_dump?

            regards, tom lane

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

Предыдущее
От: Joe Kramer
Дата:
Сообщение: Re: Help! Database restored with disabled triggers
Следующее
От: AnthonyV
Дата:
Сообщение: Advance SQL subquery