On Thu, May 24, 2012 at 8:37 PM, Thangalin <thanga...@gmail.com> wrote: > Hi, Robert. > > $ psql --version > psql (PostgreSQL) 9.1.2 > > D J
[rhaas ~]$ createdb superdatabase [rhaas ~]$ psql superdatabase Line style is old-ascii. psql (9.1.2) Type "help" for help. superdatabase=# create schema superschema; CREATE SCHEMA superdatabase=# CREATE EXTENSION unaccent; CREATE EXTENSION superdatabase=# CREATE OR REPLACE FUNCTION superschema.unaccent_text(text) superdatabase-# RETURNS text AS superdatabase-# $BODY$ superdatabase$# -- unaccent is STABLE, but the indexes must use IMMUTABLE functions. superdatabase$# SELECT unaccent($1); superdatabase$# $BODY$ superdatabase-# LANGUAGE sql IMMUTABLE superdatabase-# COST 1; CREATE FUNCTION superdatabase=# \q [rhaas ~]$ pg_dump -n superschema --inserts superdatabase > superduper.sql I tried a few other combinations, but I can't reproduce an error in pg_dump no matter what I try. Maybe you're leaving out a step or two? -- 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