On 10/15/2017 18:25, Tom Lane wrote:You are correct. Thanks; got it. (That's what I get for not being specific)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 |
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature
