"Shoaib Mir" wrote:
> I just tried it going to contrib/tsearch2 folder and then did the following:
>
> make
> make install
>
> It created a tsearch2.so file in the lib directory of pgsql which is used
> while registering the tsearch2 functions. Make sure you have that .so file
> created under the lib folder of pgsql.
>
> Hope this helps...
>
> /Shoaib
>
>
> and then it create
>
> On 17 Apr 2006 01:16:09 -0700, Danish <[EMAIL PROTECTED]> wrote:
> >
> > Hi Everyone,
> > I have installed postgresql 8.1.3.tar.gz. After compiling and
> > installing the postgresql is running fine but Im not able to install
> > tsearch2. I went under the postgresql source directory
> > /usr/local/postgresql8.1.3/contrib and then did a
> > #gmake all
> > #gmake install
> >
> > After issuing these commands, a contrib directory was created under
> > /usr/local/pgsql/share
> >
> > Going under the /usr/local/pgsql/share/contrib directory i ran the
> > command as user postgres
> >
> > $psql -d dbname -f tsearch2.sql
> > SET
> > BEGIN
> > psql:tsearch2.sql:13: NOTICE: CREATE TABLE / PRIMARY KEY will create
> > implicit index "pg_ts_dict_pkey" for table "pg_ts_dict"
> > CREATE TABLE
> > psql:tsearch2.sql:20: ERROR: could not access file "$libdir/tsearch2":
> > No suchfile or directory
> > psql:tsearch2.sql:26: ERROR: current transaction is aborted, commands
> > ignored until end of transaction block
> >
> > then i got the above errors..
> > Can anyone please help me out as to what is going wrong
> > Thanks
> > Danish
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
> >
>
> ------=_Part_16490_19174761.1145275606419
> Content-Type: text/html; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable
> X-Google-AttachSize: 2007
>
> I just tried it going to contrib/tsearch2 folder and then did the
> following:<br><br>make<br>make install<br><br>It created a tsearch2.so file
> in the lib directory of pgsql which is used while registering the tsearch2
> functions. Make sure you have that .so file created under the lib folder of
> pgsql.
> <br><br>Hope this helps...<br><br>/Shoaib<br><br><br>and then it
> create<br><br><div><span class="gmail_quote">On 17 Apr 2006 01:16:09 -0700,
> <b class="gmail_sendername">Danish</b> <<a href="mailto:[EMAIL PROTECTED]">
> [EMAIL PROTECTED]</a>> wrote:</span><blockquote class="gmail_quote"
> style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
> padding-left: 1ex;">Hi Everyone,<br>I have installed postgresql 8.1.3.tar.gz
> . After compiling and<br>installing the postgresql is running fine but Im not
> able to install<br>tsearch2. I went under the postgresql source
> directory<br>/usr/local/postgresql8.1.3/contrib and then did a<br>#gmake
> all<br>
> #gmake install<br><br>After issuing these commands, a contrib directory was
> created under<br>/usr/local/pgsql/share<br><br>Going under the
> /usr/local/pgsql/share/contrib directory i ran the<br>command as user
> postgres<br>
> <br>$psql -d dbname -f tsearch2.sql<br>SET<br>BEGIN<br>psql:tsearch2.sql:13:
> NOTICE: CREATE TABLE / PRIMARY KEY will create<br>implicit index
> "pg_ts_dict_pkey" for table "pg_ts_dict"<br>CREATE
> TABLE<br>
> psql:tsearch2.sql:20: ERROR: could not access file
> "$libdir/tsearch2":<br>No suchfile or
> directory<br>psql:tsearch2.sql:26: ERROR: current transaction is
> aborted, commands<br>ignored until end of transaction block
> <br><br>then i got the above errors..<br>Can anyone please help me out as to
> what is going
> wrong<br>Thanks<br>Danish<br><br><br>---------------------------(end of
> broadcast)---------------------------<br>TIP 2: Don't 'kill -9' the postmaster
> <br></blockquote></div><br>
>
> ------=_Part_16490_19174761.1145275606419--
Thanks, I think it worked...tsearch.sql file created a lot of functions
and I could see lot of CREATE FUNCTION INSERT statements roll by.....
Danish
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
