Re: pg_dump: SQL command failed

Поиск
Список
Период
Сортировка
От Thangalin
Тема Re: pg_dump: SQL command failed
Дата
Msg-id CAANrE7pRQ2DtqyLE3MORrBhaPd3ReHCB8MZjFBJqstvzkgy=1g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump: SQL command failed  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: pg_dump: SQL command failed
Список pgsql-bugs
Hi, Robert.

$ psql --version
psql (PostgreSQL) 9.1.2

D J

On Tue, May 22, 2012 at 12:55 PM, Robert Haas <robertmhaas@gmail.com> wrote:

> On Sun, May 13, 2012 at 10:46 PM, Thangalin <thangalin@gmail.com> wrote:
> > Hi,
> >
> > REPLICATE
> >
> > 0. Create a new database (superdatabase)
> > 1. Create a new schema (superschema)
> > 2. Add the unaccent extension to the schema:
> > CREATE EXTENSION unaccent;
> > 3. Create a wrapper for unaccent that exposes an IMMUTABLE interface
> (this
> > is side issue):
> >
> > CREATE OR REPLACE FUNCTION superschema.unaccent_text(text)
> >   RETURNS text AS
> > $BODY$
> >   -- unaccent is STABLE, but the indexes must use IMMUTABLE functions.
> >   SELECT unaccent($1);
> > $BODY$
> >   LANGUAGE sql IMMUTABLE
> >   COST 1;
> >
> > 4. Dump the schema using pg_dump:
> >
> > pg_dump -n superschema --inserts superdatabase > superduper.sql
>
> I just tried this exact series of steps and it worked for me.  What
> version are you using?
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP