From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Karl Denninger <karl(at)denninger(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Tsearch2 removal bit me - how to correct? |
Date: | 2017-10-15 23:25:13 |
Message-ID: | 28488.1508109913@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Karl Denninger <karl(at)denninger(dot)net> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-10-15 23:27:29 | Re: Tsearch2 removal bit me - how to correct? |
Previous Message | Karl Denninger | 2017-10-15 22:00:36 | Re: Tsearch2 removal bit me - how to correct? |