On Thu, May 24, 2012 at 8:37 PM, Thangalin 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 SCH
Hi, Robert.
$ psql --version
psql (PostgreSQL) 9.1.2
D J
On Tue, May 22, 2012 at 12:55 PM, Robert Haas wrote:
> On Sun, May 13, 2012 at 10:46 PM, Thangalin wrote:
> > Hi,
> >
> > REPLICATE
> >
> > 0. Create a new database (superdatabase)
> > 1. Create a new schema (superschema)
> > 2. Add the
On Sun, May 13, 2012 at 10:46 PM, Thangalin 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 interf
Hi, Tom.
Thanks for the quick reply.
anyway, for the purposes of options such as "-n".) So on reload, the
> user function fails; it's referencing a function that doesn't exist
> in the new database. That's not a bug.
>
I'm probably not understanding something: I'm not importing anything into a
Thangalin writes:
> 4. Dump the schema using pg_dump:
> pg_dump -n *superschema* --inserts *superdatabase* > superduper.sql
This does not dump the extension, because the extension is not within
the schema "superschema". (It definitely isn't given your creation
command, but pg_dump doesn't consid
Hi,
*WORKAROUND*
Until this is fixed, here is a workaround:
1. Comment out the following line:
SELECT unaccent($1);
2. Change the code to:
SELECT $1;
3. Run pg_dump as before.
4. Remember to reinstate the old code. ;-)
Works as expected.
Thank you!
Dave
On Sun, May 13, 2012 at
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 supers
