Re: pg_dump: SQL command failed

On Thu, May 24, 2012 at 8:37 PM, Thangalin <thangalin(at)gmail(dot)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