Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4C276633066 for ; Thu, 12 Feb 2009 12:25:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28883-05 for ; Thu, 12 Feb 2009 12:25:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 4F12E633074 for ; Thu, 12 Feb 2009 12:25:21 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n1CGPHiP010980; Thu, 12 Feb 2009 11:25:17 -0500 (EST) To: Carol Walter cc: pgsql-admin@postgresql.org Subject: Re: Tsearch module - please help. In-reply-to: <7283C329-D249-46E3-89DD-02C7445372F8@indiana.edu> References: <3BB6A499-05A1-4638-9808-EC8B46BD68D8@indiana.edu> <15977.1234388844@sss.pgh.pa.us> <7283C329-D249-46E3-89DD-02C7445372F8@indiana.edu> Comments: In-reply-to Carol Walter message dated "Thu, 12 Feb 2009 10:08:20 -0500" Date: Thu, 12 Feb 2009 11:25:17 -0500 Message-ID: <10979.1234455917@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/80 X-Sequence-Number: 31301 Carol Walter writes: > ... All worked well except for two tables. These tables > are called pg_ts_dict and pg_ts_parser. I cannot copy the data from > these tables into my new database because the functions that are in > their columns do not exist in the database. There are two other > tables with names that also suggest that they are related to full text > searching. They are pg_ts_cfg and pg_ts_cfgmap. This is the only > database in the cluster that uses or tries to use full text searching. See the discussion of 8.2 to 8.3 tsearch porting in the 8.3 docs I pointed you to before; particularly the revised contrib/tsearch2 module. regards, tom lane