Hi,
I wrote the unaccent_text wrapper function to achieve the following:
CREATE INDEX table_name_label_unaccent_idx
ON table_name
USING gin
(unaccent_text(label::text) COLLATE pg_catalog."default" gin_trgm_ops);
I would have liked to use unaccent directly.
The fact that someone wrote such
Hi,
Given the following function:
CREATE OR REPLACE FUNCTION unaccent_text(text)
RETURNS text AS
$BODY$
-- unaccent is STABLE, but the indexes must use IMMUTABLE functions.
-- comment this line out when calling pg_dump.
SELECT unaccent($1);
-- Uncomment this line when calling pg_dump.
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. Creat
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
at 7: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 *IMMU
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
The following bug has been logged on the website:
Bug reference: 6368
Logged by: D J
Email address: thanga...@gmail.com
PostgreSQL version: 9.1.2
Operating system: Kubuntu Linux 10.10
Description:
Running the following command resolved the issue of a missing pg_config
The following bug has been logged on the website:
Bug reference: 6367
Logged by: D J
Email address: thanga...@gmail.com
PostgreSQL version: 9.1.2
Operating system: Kubuntu Linux 10.10
Description:
REPLICATE
1. Clean OS.
2. Use "synaptic" to install postgresql-8.4 pack
