Hello, When I describe the tables in the user's database that are related to tsearch they look as follows: template1=# \c citesrch You are now connected to database "citesrch". citesrch=# \d pg_ts_dict Table "public.pg_ts_dict" Column | Type | Modifiers -----------------+--------------+----------- dict_name | text | not null dict_init | regprocedure | dict_initoption | text | dict_lexize | regprocedure | not null dict_comment | text | Indexes: "pg_ts_dict_pkey" PRIMARY KEY, btree (dict_name) citesrch=# \d pg_ts_parser Table "public.pg_ts_parser" Column | Type | Modifiers ---------------+--------------+----------- prs_name | text | not null prs_start | regprocedure | not null prs_nexttoken | regprocedure | not null prs_end | regprocedure | not null prs_headline | regprocedure | not null prs_lextype | regprocedure | not null prs_comment | text | Indexes: "pg_ts_parser_pkey" PRIMARY KEY, btree (prs_name) These tables exist in my user's database and look like any other user table. If I search for functions that have names similar to the ones I see in the user table, I get records as follows: citesrch=# select * from pg_proc where proname like 'pr%'; proname | pronamespace | proowner | prolang | proisagg | prosecdef | proisstrict | proretset | provolatile | pronargs | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | prosrc | probin | proacl ----------------+--------------+----------+---------+----------+-----------+-------------+-----------+-------------+----------+------------+----------------+----------------+-------------+-------------+----------------+------------------+-------- prsd_end | 2200 | 10 | 13 | f | f | f | f | v | 1 | 2278 | 2281 | | | | prsd_end | $libdir/tsearch2 | prsd_getlexeme | 2200 | 10 | 13 | f | f | f | f | v | 3 | 23 | 2281 2281 2281 | | | | prsd_getlexeme | $libdir/tsearch2 | prsd_headline | 2200 | 10 | 13 | f | f | f | f | v | 3 | 2281 | 2281 2281 2281 | | | | prsd_headline | $libdir/tsearch2 | prsd_lextype | 2200 | 10 | 13 | f | f | f | f | v | 1 | 2281 | 2281 | | | | prsd_lextype | $libdir/tsearch2 | prsd_start | 2200 | 10 | 13 | f | f | f | f | v | 2 | 2281 | 2281 23 | | | | prsd_start | $libdir/tsearch2 | (5 rows) citesrch=# select * from pg_proc where proname like '%dict%'; proname | pronamespace | proowner | prolang | proisagg | prosecdef | proisstrict | proretset | provolatile | pronargs | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | prosrc | probin | proacl -------------+--------------+----------+---------+----------+-----------+-------------+-----------+-------------+----------+------------+-------------+----------------+-------------+-------------+--------------------+------------------+-------- set_curdict | 2200 | 10 | 13 | f | f | t | f | v | 1 | 2278 | 23 | | | | set_curdict | $libdir/tsearch2 | set_curdict | 2200 | 10 | 13 | f | f | t | f | v | 1 | 2278 | 25 | | | | set_curdict_byname | $libdir/tsearch2 | (2 rows) On Feb 6, 2009, at 2:35 PM, Joshua D. Drake wrote:
|
