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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
