Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0D136632DFF for ; Tue, 3 Aug 2010 15:29:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 12521-09 for ; Tue, 3 Aug 2010 18:29:44 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qy0-f174.google.com (mail-qy0-f174.google.com [209.85.216.174]) by mail.postgresql.org (Postfix) with ESMTP id D8A6B632B31 for ; Tue, 3 Aug 2010 15:29:43 -0300 (ADT) Received: by qyk7 with SMTP id 7so406618qyk.19 for ; Tue, 03 Aug 2010 11:29:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :x-enigmail-version:content-type:content-transfer-encoding; bh=SEV3UbgFeUUC7sS83s3Na86IH4Y1nWaXM+1KuP6JnCU=; b=b73PaLQ67qnyyUMCvNL4pWZfxRxtvKFG6/LKLMoQCvGnJB+zyoBr1LucjQHwcgKO9V auJbyppNh4NgyBRxqIFJ1Pe/qzW2rxC9i3QUvgAMcJXBgtzeIqZWaq/iQxP/+UAy/ojY CWSc8ftDWB1TNhvwY2XFWXSxAo/0FpLS7tK4Q= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:x-enigmail-version:content-type :content-transfer-encoding; b=DgsiUm3c2WDqirBiDMVwZzr8wCiVCXyfmk/j9H+qcSkCxLXKCh+XvRZpqfmTKbfwyj xuT+nBirPmOWvJooIfboI1tI0slUEu0oBPlltwYCOyfbXXBJtDRecOfSoRHJ6aE2uvrV OTTBF3wiqNFWn1Aw1vgZmaYICzDxDorgBiBgg= Received: by 10.220.87.70 with SMTP id v6mr5490797vcl.226.1280860182908; Tue, 03 Aug 2010 11:29:42 -0700 (PDT) Received: from schism.local (173-161-130-225-Philadelphia.hfc.comcastbusiness.net [173.161.130.225]) by mx.google.com with ESMTPS id w1sm7007556vbl.8.2010.08.03.11.29.39 (version=SSLv3 cipher=RC4-MD5); Tue, 03 Aug 2010 11:29:40 -0700 (PDT) Message-ID: <4C586014.7030900@gmail.com> Date: Tue, 03 Aug 2010 14:29:40 -0400 From: Glen Barber User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.7) Gecko/20100713 Thunderbird/3.1.1 MIME-Version: 1.0 To: Bruce Momjian CC: Josh Berkus , pgsql-testers@postgresql.org Subject: Re: pg_upgrade and reg* system oid user types References: <201008031819.o73IJfU23806@momjian.us> In-Reply-To: <201008031819.o73IJfU23806@momjian.us> X-Enigmail-Version: 1.1.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/5 X-Sequence-Number: 160 On 8/3/10 2:19 PM, Bruce Momjian wrote: > Josh Berkus wrote: >> On 8/3/10 10:07 AM, Glen Barber wrote: >>> Hi, >>> >>> I think it might be worth mentioning in the release notes (unless I've >>> missed it, of course) that, with the addition of >>> check_for_reg_data_type_usage(), pg_upgrade will error if it finds, for >>> example, tsearch data from pre-8.3 in user tables. >>> >>> Otherwise, pg_upgrade has worked wonderfully for me - thanks again for >>> bringing it into contrib. >> >> Good to hear. Problem report forwarded to Bruce. > > I was wondering if users were storing text search reg* data types in > their user tables. Is this common? Why only pre-8.3? > The database I am using in testing 9.0 is a development database which mimics our production environment as closely as it can. This particular data has been through several PostgreSQL upgrades, beginning with 7.4, if I remember correctly. The reg* data types in user tables is from before tsearch functionality was added to core. Regards, -- Glen Barber