| Lists: | pgsql-general |
|---|
| From: | "Janek Sendrowski" <janek12(at)web(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Regex files are missing |
| Date: | 2013-11-18 15:34:44 |
| Message-ID: | trinity-9ccd4188-79b3-477e-b495-ca63b7213656-1384788884121@3capp-webde-bs08 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi,
Have some issues to built the pg_trgm module from source.
For first the regexport.h file was missing in /usr/include, so I got it.
Now I still need the the regexport.c file and probably also the other one
You can see the files in this link:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/backend/regex;h=a30f70549052ee6828616d933d72d0ea84922ba7;hb=refs/heads/master
But I don't know where to put them. I don't have a usr/backend directory in ubuntu.
Anyways it's very weird. Why don't I have these files?
Do I have to install something for example.
Hope there is someone who can help me
Janek Sendrowski
| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Janek Sendrowski <janek12(at)web(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Regex files are missing |
| Date: | 2013-11-18 15:53:34 |
| Message-ID: | 528A37FE.40208@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On 11/18/2013 07:34 AM, Janek Sendrowski wrote:
> Hi,
>
> Have some issues to built the pg_trgm module from source.
> For first the regexport.h file was missing in /usr/include, so I got it.
> Now I still need the the regexport.c file and probably also the other one
> You can see the files in this link:
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/backend/regex;h=a30f70549052ee6828616d933d72d0ea84922ba7;hb=refs/heads/master
>
> But I don't know where to put them. I don't have a usr/backend directory in ubuntu.
> Anyways it's very weird. Why don't I have these files?
> Do I have to install something for example.
>
> Hope there is someone who can help me
FYI I find those files in the source I downloaded from the Postgres site:
aklaver(at)panda:~/test/postgresql-9.3.1> find -name regexport.c
./src/backend/regex/regexport.c
aklaver(at)panda:~/test/postgresql-9.3.1> find -name regexport.h
./src/include/regex/regexport.h
So:
What version of Postgres are you working with?
Where did you get your source code?
How are you doing your build?
>
> Janek Sendrowski
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | Janek Sendrowski <janek12(at)web(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Regex files are missing |
| Date: | 2013-11-18 16:10:17 |
| Message-ID: | 13151.1384791017@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> writes:
> On 11/18/2013 07:34 AM, Janek Sendrowski wrote:
>> Have some issues to built the pg_trgm module from source.
> FYI I find those files in the source I downloaded from the Postgres site:
Sounds like Janek is trying to build 9.3 pg_trgm against a pre-9.3
server installation. Won't work. Get the matching version of pg_trgm.
regards, tom lane
| From: | "Janek Sendrowski" <janek12(at)web(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Regex files are missing |
| Date: | 2013-11-18 16:32:29 |
| Message-ID: | trinity-82d0c4c8-a2d1-459b-88a5-dfd5e93bbab5-1384792349576@3capp-webde-bs32 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>Hi,</div>
<div> </div>
<div>My current version is 9.2. I could just update it.</div>
<div>I got the pg_trgm from here:</div>
<div>http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=contrib/pg_trgm;hb=refs/heads/master</div>
<div> </div>
<div>And the regex files from here:</div>
<div> </div>
<div>Where could I get the matching version of pg_trgm?</div>
<div> </div>
<div>Janek Sendrowksi</div>
</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 706 bytes |
| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Janek Sendrowski <janek12(at)web(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Regex files are missing |
| Date: | 2013-11-18 18:58:06 |
| Message-ID: | 528A633E.9060803@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On 11/18/2013 08:32 AM, Janek Sendrowski wrote:
> Hi,
> My current version is 9.2. I could just update it.
> I got the pg_trgm from here:
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=contrib/pg_trgm;hb=refs/heads/master
> And the regex files from here:
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/include/regex;h=f65341c80ea8516a1e02a8b57d9c27d3034eaba4;hb=refs/heads/master
> Where could I get the matching version of pg_trgm?
So you are trying to backport the development version of pg_trgm to 9.2?
I may be wandering out of my depth here, but I am going to say that is
not going to work. Others may have a better grasp on the feasibility of
doing that though.
If it is not otherwise a problem I would suggest upgrading to 9.3, which
has the features you want. Of course this is a major upgrade with all
that entails, so proceed with caution.
> Janek Sendrowksi
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Janek Sendrowski <janek12(at)web(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Regex files are missing |
| Date: | 2013-11-18 19:51:45 |
| Message-ID: | 1384804305.51780.YahooMailNeo@web162901.mail.bf1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Janek Sendrowski <janek12(at)web(dot)de> wrote:
> My current version is 9.2. I could just update it.
> I got the pg_trgm from here:
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=contrib/pg_trgm;hb=refs/heads/master
Get a production release version from the snapshot tarball
downloads or use a URL that looks more like one of these:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=contrib/pg_trgm;hb=refs/tags/REL9_2_5
> And the regex files from here:
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/include/regex;h=f65341c80ea8516a1e02a8b57d9c27d3034eaba4;hb=refs/heads/master
The include files should be under your installation directory. You
should not need to download those. To use the installed include
files when you build, see this page:
http://www.postgresql.org/docs/9.2/static/extend-pgxs.html
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From: | "Janek Sendrowski" <janek12(at)web(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Regex files are missing |
| Date: | 2013-11-19 20:22:54 |
| Message-ID: | trinity-6f10ae85-130a-4b94-b799-af0e169192b4-1384892574065@3capp-webde-bs07 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Thanks for your help!
I updated to version 9.3 and now it's working.
Janek Sendrowski