Re: pg_trgm

#11

Marian Aldenhövel <marian (AT) mba-software (DOT) de> wrote:

Quote:

There should be a file README.pg_trgm and a file pg_trgm.sql on your
system.

I have confirmed that there are no *pg_trgm* files on the system.

I looked at the package you downloaded, and it really does only contain
one contrib module, namely tsearch2.

Quote:

Before posting I had downloaded the source to the module from

http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/

An checked the contents. It includes a README, but that does not tell
me anything about installation, just how to use the functions.

There is a pg_trgm.sql.in that apparently needs to be processed through
a build process to arrive at something useable:

..
create function set_limit(float4)
returns float4
AS 'MODULE_PATHNAME'
LANGUAGE 'C' with (isstrict,iscachable);

pg_trgm.sql from the package is a set of tests demonstrating the functions.

So does the fact that I don't have a file called pg_trgm.so or such mean
that my package does not include/support the module? That I would have to
build it from source?

Yes, that's the way it looks.

The site you quoted in your original post contains "Build Instructions"
which may make the task easier.

I have no idea why the packagers decided to omit most of the contrib
modules, maybe you can ask them...

There are also good build instructions in the original PostgreSQL
documentation. It shouldn't be too hard, but you'll need a development
machine where you can install all the required software.

Be sure to use the same PostgreSQL version for everything!

Maybe you can use this to convince your bosses that
a) they should invest some money into letting you learn PostgreSQL
b) you might as well update to 8.2.7 while you're at it.

Yours,
Laurenz Albe

#12

Marian Aldenhövel <marian (AT) mba-software (DOT) de> wrote:

Quote:

There should be a file README.pg_trgm and a file pg_trgm.sql on your
system.

I have confirmed that there are no *pg_trgm* files on the system.

I looked at the package you downloaded, and it really does only contain
one contrib module, namely tsearch2.

Quote:

Before posting I had downloaded the source to the module from

http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/

An checked the contents. It includes a README, but that does not tell
me anything about installation, just how to use the functions.

There is a pg_trgm.sql.in that apparently needs to be processed through
a build process to arrive at something useable:

..
create function set_limit(float4)
returns float4
AS 'MODULE_PATHNAME'
LANGUAGE 'C' with (isstrict,iscachable);

pg_trgm.sql from the package is a set of tests demonstrating the functions.

So does the fact that I don't have a file called pg_trgm.so or such mean
that my package does not include/support the module? That I would have to
build it from source?

Yes, that's the way it looks.

The site you quoted in your original post contains "Build Instructions"
which may make the task easier.

I have no idea why the packagers decided to omit most of the contrib
modules, maybe you can ask them...

There are also good build instructions in the original PostgreSQL
documentation. It shouldn't be too hard, but you'll need a development
machine where you can install all the required software.

Be sure to use the same PostgreSQL version for everything!

Maybe you can use this to convince your bosses that
a) they should invest some money into letting you learn PostgreSQL
b) you might as well update to 8.2.7 while you're at it.

Yours,
Laurenz Albe

#13

Marian Aldenhövel <marian (AT) mba-software (DOT) de> wrote:

Quote:

There should be a file README.pg_trgm and a file pg_trgm.sql on your
system.

I have confirmed that there are no *pg_trgm* files on the system.

I looked at the package you downloaded, and it really does only contain
one contrib module, namely tsearch2.

Quote:

Before posting I had downloaded the source to the module from

http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/

An checked the contents. It includes a README, but that does not tell
me anything about installation, just how to use the functions.

There is a pg_trgm.sql.in that apparently needs to be processed through
a build process to arrive at something useable:

..
create function set_limit(float4)
returns float4
AS 'MODULE_PATHNAME'
LANGUAGE 'C' with (isstrict,iscachable);

pg_trgm.sql from the package is a set of tests demonstrating the functions.

So does the fact that I don't have a file called pg_trgm.so or such mean
that my package does not include/support the module? That I would have to
build it from source?

Yes, that's the way it looks.

The site you quoted in your original post contains "Build Instructions"
which may make the task easier.

I have no idea why the packagers decided to omit most of the contrib
modules, maybe you can ask them...

There are also good build instructions in the original PostgreSQL
documentation. It shouldn't be too hard, but you'll need a development
machine where you can install all the required software.

Be sure to use the same PostgreSQL version for everything!

Maybe you can use this to convince your bosses that
a) they should invest some money into letting you learn PostgreSQL
b) you might as well update to 8.2.7 while you're at it.

Yours,
Laurenz Albe

#14

Marian Aldenhövel <marian (AT) mba-software (DOT) de> wrote:

Quote:

There should be a file README.pg_trgm and a file pg_trgm.sql on your
system.

I have confirmed that there are no *pg_trgm* files on the system.

I looked at the package you downloaded, and it really does only contain
one contrib module, namely tsearch2.

Quote:

Before posting I had downloaded the source to the module from

http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/

An checked the contents. It includes a README, but that does not tell
me anything about installation, just how to use the functions.

There is a pg_trgm.sql.in that apparently needs to be processed through
a build process to arrive at something useable:

..
create function set_limit(float4)
returns float4
AS 'MODULE_PATHNAME'
LANGUAGE 'C' with (isstrict,iscachable);

pg_trgm.sql from the package is a set of tests demonstrating the functions.

So does the fact that I don't have a file called pg_trgm.so or such mean
that my package does not include/support the module? That I would have to
build it from source?

Yes, that's the way it looks.

The site you quoted in your original post contains "Build Instructions"
which may make the task easier.

I have no idea why the packagers decided to omit most of the contrib
modules, maybe you can ask them...

There are also good build instructions in the original PostgreSQL
documentation. It shouldn't be too hard, but you'll need a development
machine where you can install all the required software.

Be sure to use the same PostgreSQL version for everything!

Maybe you can use this to convince your bosses that
a) they should invest some money into letting you learn PostgreSQL
b) you might as well update to 8.2.7 while you're at it.

Yours,
Laurenz Albe

#15

Marian Aldenhövel <marian (AT) mba-software (DOT) de> wrote:

Quote:

There should be a file README.pg_trgm and a file pg_trgm.sql on your
system.

I have confirmed that there are no *pg_trgm* files on the system.

I looked at the package you downloaded, and it really does only contain
one contrib module, namely tsearch2.

Quote:

Before posting I had downloaded the source to the module from

http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/

An checked the contents. It includes a README, but that does not tell
me anything about installation, just how to use the functions.

There is a pg_trgm.sql.in that apparently needs to be processed through
a build process to arrive at something useable:

..
create function set_limit(float4)
returns float4
AS 'MODULE_PATHNAME'
LANGUAGE 'C' with (isstrict,iscachable);

pg_trgm.sql from the package is a set of tests demonstrating the functions.

So does the fact that I don't have a file called pg_trgm.so or such mean
that my package does not include/support the module? That I would have to
build it from source?

Yes, that's the way it looks.

The site you quoted in your original post contains "Build Instructions"
which may make the task easier.

I have no idea why the packagers decided to omit most of the contrib
modules, maybe you can ask them...

There are also good build instructions in the original PostgreSQL
documentation. It shouldn't be too hard, but you'll need a development
machine where you can install all the required software.

Be sure to use the same PostgreSQL version for everything!

Maybe you can use this to convince your bosses that
a) they should invest some money into letting you learn PostgreSQL
b) you might as well update to 8.2.7 while you're at it.

Yours,
Laurenz Albe

#16

Marian Aldenhövel <marian (AT) mba-software (DOT) de> wrote:

Quote:

There should be a file README.pg_trgm and a file pg_trgm.sql on your
system.

I have confirmed that there are no *pg_trgm* files on the system.

I looked at the package you downloaded, and it really does only contain
one contrib module, namely tsearch2.

Quote:

Before posting I had downloaded the source to the module from

http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/

An checked the contents. It includes a README, but that does not tell
me anything about installation, just how to use the functions.

There is a pg_trgm.sql.in that apparently needs to be processed through
a build process to arrive at something useable:

..
create function set_limit(float4)
returns float4
AS 'MODULE_PATHNAME'
LANGUAGE 'C' with (isstrict,iscachable);

pg_trgm.sql from the package is a set of tests demonstrating the functions.

So does the fact that I don't have a file called pg_trgm.so or such mean
that my package does not include/support the module? That I would have to
build it from source?

Yes, that's the way it looks.

The site you quoted in your original post contains "Build Instructions"
which may make the task easier.

I have no idea why the packagers decided to omit most of the contrib
modules, maybe you can ask them...

There are also good build instructions in the original PostgreSQL
documentation. It shouldn't be too hard, but you'll need a development
machine where you can install all the required software.

Be sure to use the same PostgreSQL version for everything!

Maybe you can use this to convince your bosses that
a) they should invest some money into letting you learn PostgreSQL
b) you might as well update to 8.2.7 while you're at it.

Yours,
Laurenz Albe

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: pg_trgm

comp.databases.postgresql comp.databases.postgresql

Re: pg_trgm - 04-10-2008 , 08:47 AM

Re: pg_trgm - 04-10-2008 , 08:47 AM

Re: pg_trgm - 04-10-2008 , 08:47 AM

Re: pg_trgm - 04-10-2008 , 08:47 AM

Re: pg_trgm - 04-10-2008 , 08:47 AM

Re: pg_trgm - 04-10-2008 , 08:47 AM