Re: Tsearch2 removal bit me - how to correct?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/15/2017 18:42, Karl Denninger wrote:
On 10/15/2017 18:25, Tom Lane wrote:
Karl Denninger <karl@xxxxxxxxxxxxx> writes:
That worked on one of my clusters, but on another I'm seeing entries in
pg_catalog, and can't remove them.
pgsql=# \c fapforum
You are now connected to database "fapforum" as user "pgsql".
fapforum=# select proname from pg_proc where probin like '%tsearch2%';
    proname
----------------
 prsd_end
 prsd_lextype
 prsd_start
 thesaurus_init
(4 rows)
There *should* be a pg_catalog.prsd_end built-in function, but it's
going to have null probin.  I think you're being careless about
schema names here.

fapforum=# \df prsd_end;
                            List of functions
   Schema   |   Name   | Result data type | Argument data types |  Type
------------+----------+------------------+---------------------+--------
 pg_catalog | prsd_end | void             | internal            | normal
(1 row)
This does not prove that there's not a, say, public.prsd_end.  Try
"\df *.prsd_end" to see all the functions by that name.

			regards, tom lane
You are correct.  Thanks; got it.  (That's what I get for not being specific)

One more question - for safety do I also need to drop all the other previously-declared public functions such as rank*() (in all its forms) and concat even thought they do not reference the shared library, or are they safe to leave there?  I see there are pg_catalog copies of these as well....

--
Karl Denninger
karl@xxxxxxxxxxxxx
The Market Ticker
[S/MIME encrypted email preferred]

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux