Re: normal user dump gives error because of plpgsql

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: normal user dump gives error because of plpgsql
Дата
Msg-id 15964.1110475073@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: normal user dump gives error because of plpgsql  (John Sidney-Woollett <johnsw@wardbrook.com>)
Ответы Re: normal user dump gives error because of plpgsql  (John Sidney-Woollett <johnsw@wardbrook.com>)
Re: normal user dump gives error because of plpgsql  (Janning Vygen <vygen@gmx.de>)
Список pgsql-general
John Sidney-Woollett <johnsw@wardbrook.com> writes:
> I'm pretty sure I had the same problem when using pg_restore. If
> pl/pgsql is installed in template1, then the restore fails.

> And I couldn't find any solution to this on the list either.

You're supposed to restore into a database cloned from template0,
not template1.

> Can pg_restore be made to ignore the error?

It does, at least since 8.0.

            regards, tom lane

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

Предыдущее
От: John Sidney-Woollett
Дата:
Сообщение: Re: normal user dump gives error because of plpgsql
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: PostgreSQL still for Linux only?