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
