Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e3sHY-0000Wp-IO for pgsql-admin@arkaria.postgresql.org; Sun, 15 Oct 2017 23:25:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e3sHY-0001Ne-4t for pgsql-admin@arkaria.postgresql.org; Sun, 15 Oct 2017 23:25:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e3sHX-0001Mo-Hd for pgsql-admin@postgresql.org; Sun, 15 Oct 2017 23:25:19 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e3sHU-0005qB-8s for pgsql-admin@postgresql.org; Sun, 15 Oct 2017 23:25:18 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id v9FNPD8Q028489; Sun, 15 Oct 2017 19:25:13 -0400 From: Tom Lane To: Karl Denninger cc: pgsql-admin@postgresql.org Subject: Re: Tsearch2 removal bit me - how to correct? In-reply-to: <25ef2548-e569-ba17-5902-5676f8fc62db@denninger.net> References: <64d687df-3a87-0e4a-e954-f2f23c2581c9@denninger.net> <19742.1508082461@sss.pgh.pa.us> <25ef2548-e569-ba17-5902-5676f8fc62db@denninger.net> Comments: In-reply-to Karl Denninger message dated "Sun, 15 Oct 2017 14:49:59 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <28487.1508109913.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Sun, 15 Oct 2017 19:25:13 -0400 Message-ID: <28488.1508109913@sss.pgh.pa.us> List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Karl Denninger writes: > That worked on one of my clusters, but on another I'm seeing entries in > pg_catalog, and can't remove them. > pgsql=3D# \c fapforum > You are now connected to database "fapforum" as user "pgsql". > fapforum=3D# select proname from pg_proc where probin like '%tsearch2%'; > =C2=A0=C2=A0=C2=A0 proname > ---------------- > =C2=A0prsd_end > =C2=A0prsd_lextype > =C2=A0prsd_start > =C2=A0thesaurus_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=3D# \df prsd_end; > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 List of functions > =C2=A0=C2=A0 Schema=C2=A0=C2=A0 |=C2=A0=C2=A0 Name=C2=A0=C2=A0 | Result d= ata type | Argument data types |=C2=A0 Type > ------------+----------+------------------+---------------------+-------- > =C2=A0pg_catalog | prsd_end | void=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | internal=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | 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 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin