Hi, Robert. $ psql --version psql (PostgreSQL) 9.1.2
D J On Tue, May 22, 2012 at 12:55 PM, Robert Haas <robertmh...@gmail.com> wrote: > 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 >
