Re: pg_dump: SQL command failed

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
>