On Sun, May 13, 2012 at 10:46 PM, Thangalin <thanga...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs