Re: [ADMIN] Tsearch2 removal bit me - how to correct?

Karl Denninger <karl@denninger.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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin