Thread: Using pg_trgm

Using pg_trgm

From
JORGE MALDONADO
Date:
I tried to use the "similarity" function to detect possible duplicated in a table but it is not recognized. Is there something I have to do before using it? What is the correct procedure to get it working?

Respectfully,
Jorge Maldonado

Re: Using pg_trgm

From
Andreas Kretschmer
Date:
JORGE MALDONADO <jorgemal1960@gmail.com> wrote:

> I tried to use the "similarity" function to detect possible duplicated in a
> table but it is not recognized. Is there something I have to do before using
> it? What is the correct procedure to get it working?

Create extension?

test=# create extension pg_trgm;
CREATE EXTENSION
Time: 176,301 ms



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Re: Using pg_trgm

From
Andreas Kretschmer
Date:
JORGE MALDONADO <jorgemal1960@gmail.com> wrote:

> Thanks for your reply.
> I am issuing the "create extension" command but I get an error message saying
> that there is a syntax error in or near the word "extension".
> What can be happening?

Which version you are using?




>
> Regards,
> Jorge Maldonado
>
> On Tue, Mar 13, 2012 at 10:51 AM, Andreas Kretschmer <akretschmer@spamfence.net
> > wrote:
>
>     JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
>
>     > I tried to use the "similarity" function to detect possible duplicated in
>     a
>     > table but it is not recognized. Is there something I have to do before
>     using
>     > it? What is the correct procedure to get it working?
>
>     Create extension?
>
>     test=# create extension pg_trgm;
>     CREATE EXTENSION
>     Time: 176,301 ms
>
>
>
>     Andreas
>     --
>     Really, I'm not out to destroy Microsoft. That will just be a completely
>     unintentional side effect.                              (Linus Torvalds)
>     "If I was god, I would recompile penguin with --enable-fly."   (unknown)
>     Kaufbach, Saxony, Germany, Europe.              N 51.05082 , E 13.56889
>
>     --
>     Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-novice
>
>


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Re: Using pg_trgm

From
Andreas Kretschmer
Date:
JORGE MALDONADO <jorgemal1960@gmail.com> wrote:

> PostgreSQL 9.0
>
> Regards,
> Jorge Maldonado

1st: don't top-quoting
2nd: answer to the list, not to me
3rd: Extensions are new since 9.1, so you have to run the
install-script, please read
http://www.postgresql.org/docs/9.0/static/contrib.html how to install
contrib-modules.


Regards, Andreas


--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°