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
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
Thangalin thanga...@gmail.com 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