Skip site navigation (1) Skip section navigation (2)

Re: pg_dump: SQL command failed

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Thangalin <thangalin(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump: SQL command failed
Date: 2012-05-29 17:40:08
Message-ID: CA+Tgmoaw3mkfSAGN=ujBZKxbUcjrPBgeBL3QHE1rWEVaDbraZQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-05-29 22:05:25
Subject: Re: [HACKERS] Re: 9.2beta1 regression: pg_restore --data-only does not set sequence values any more
Previous:From: Tom LaneDate: 2012-05-29 16:49:30
Subject: Re: i cannot able to delete the sql function permenently

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group