MIME-Version: 1.0
In-Reply-To: <27739.1522214819@sss.pgh.pa.us>
References: 
 <CAOC+FBW50neMHjhcYymtyxDk_c-16MO-m8N_E0z4ZAJnqUzM6A@mail.gmail.com>
 <27739.1522214819@sss.pgh.pa.us>
From: Wells Oliver <wells.oliver@gmail.com>
Date: Wed, 28 Mar 2018 09:15:58 -0700
Message-ID: 
 <CAOC+FBXSDTBMLPDfF8AdNpumT2hehdLMfuGVVSWabsoF1re33w@mail.gmail.com>
Subject: Re: postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2
 unloadable...
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="001a11c035daebbfdb05687b5472"
Precedence: bulk

--001a11c035daebbfdb05687b5472
Content-Type: text/plain; charset="UTF-8"

Thanks. I ran: select * from pg_proc where probin like '%tsearch%';

This showed 38 functions. I believe I need to drop these, correct? However,
I am using to_tsvector() and to_tsquery(), but I believe these are now part
of the core postgres package, and I can safely drop these where probin
contains tsearch2. Am I correct, or do I need to rewrite things that use
to_tsvector()?

Thanks for any clarification.


On Tue, Mar 27, 2018 at 10:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Wells Oliver <wells.oliver@gmail.com> writes:
> > I get that this library is no longer need. It's blowing up my upgrade to
> > 10. Output:
> > could not load library "$libdir/tsearch2": ERROR:  could not access file
> > "$libdir/tsearch2": No such file or directory
>
> > But I can't see how or where this library is still installed. Running \dx
> > on my database:
>
> Did you check every database in the cluster?
>
> If you did, then maybe you have some "loose" (pre-extensions) tsearch2
> functions laying about somewhere.  Look through pg_proc for functions
> with probin = '$libdir/tsearch2'.  Again, check every DB.
>
>                         regards, tom lane
>


-- 
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>

--001a11c035daebbfdb05687b5472
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks. I ran:=C2=A0select * from pg_proc where probin lik=
e &#39;%tsearch%&#39;;<div><br></div><div>This showed 38 functions. I belie=
ve I need to drop these, correct? However, I am using to_tsvector() and to_=
tsquery(), but I believe these are now part of the core postgres package, a=
nd I can safely drop these where probin contains tsearch2. Am I correct, or=
 do I need to rewrite things that use to_tsvector()?</div><div><br></div><d=
iv>Thanks for any clarification.</div><div><br></div><div><br></div></div><=
div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Tue, Mar 27, 20=
18 at 10:26 PM, Tom Lane <span dir=3D"ltr">&lt;<a href=3D"mailto:tgl@sss.pg=
h.pa.us" target=3D"_blank">tgl@sss.pgh.pa.us</a>&gt;</span> wrote:<br><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #cc=
c solid;padding-left:1ex"><span class=3D"">Wells Oliver &lt;<a href=3D"mail=
to:wells.oliver@gmail.com">wells.oliver@gmail.com</a>&gt; writes:<br>
&gt; I get that this library is no longer need. It&#39;s blowing up my upgr=
ade to<br>
&gt; 10. Output:<br>
</span><span class=3D"">&gt; could not load library &quot;$libdir/tsearch2&=
quot;: ERROR:=C2=A0 could not access file<br>
&gt; &quot;$libdir/tsearch2&quot;: No such file or directory<br>
<br>
&gt; But I can&#39;t see how or where this library is still installed. Runn=
ing \dx<br>
&gt; on my database:<br>
<br>
</span>Did you check every database in the cluster?<br>
<br>
If you did, then maybe you have some &quot;loose&quot; (pre-extensions) tse=
arch2<br>
functions laying about somewhere.=C2=A0 Look through pg_proc for functions<=
br>
with probin =3D &#39;$libdir/tsearch2&#39;.=C2=A0 Again, check every DB.<br=
>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><d=
iv>Wells Oliver<br><a href=3D"mailto:wellsoliver@gmail.com" target=3D"_blan=
k">wells.oliver@gmail.com</a></div></div></div>
</div>

--001a11c035daebbfdb05687b5472--