Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 07A0A633274 for ; Tue, 3 Aug 2010 15:46:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 71233-06 for ; Tue, 3 Aug 2010 18:46:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id 776FE632BCC for ; Tue, 3 Aug 2010 15:46:50 -0300 (ADT) Received: by vws3 with SMTP id 3so3292578vws.19 for ; Tue, 03 Aug 2010 11:46:48 -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=yC0a2/1dE9ZxE0rIzCWo/zDM0vK3YHnu9N7PbLJP05I=; b=M6gYxvd6RHAW6haLGLVInc8RrbjOrPbT6eLHNL5B134pg15Y6eUOZgmA1k7vauCeE1 p2D4ezhguPF+hiwoDUOnCzhJCSVz/xO0Ruso950BlV/1bmq1CN8BLrpokK2+6N/jAJ5K 64YcSmEUIiAzn9XqX/k1EjVTnO8PJzpGhvnQ4= 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=KsUj5G/QcUryvh6G93cmnsO6YlVLZN8ejau/fM0bweHbfJQ02wCC5wH1mD98ZyvC35 OBYqzxXNyFf6wsgo8BeeLL3dIFVsEmaggFxB6elsorO3RoB9guWbK5AAD+Ub+3ggtxrF 0KfeX2BhKvFTFqw3Oagm+raWjnm2Tp/8EBCyU= Received: by 10.220.75.200 with SMTP id z8mr5481249vcj.197.1280861208644; Tue, 03 Aug 2010 11:46:48 -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 v11sm7019452vbb.4.2010.08.03.11.46.46 (version=SSLv3 cipher=RC4-MD5); Tue, 03 Aug 2010 11:46:47 -0700 (PDT) Message-ID: <4C586416.1050608@gmail.com> Date: Tue, 03 Aug 2010 14:46:46 -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: <201008031836.o73Ia7026565@momjian.us> In-Reply-To: <201008031836.o73Ia7026565@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/7 X-Sequence-Number: 162 On 8/3/10 2:36 PM, Bruce Momjian wrote: >>> 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. > > OK, good to know. I am hoping that isn't something that many people > have in their databases. We can fix the reg* migration, but it is too > late for 9.0 and fixing it will require additional code in the backend > that we would prefer to avoid. > I wasn't sure if it would be common. I was able to move forward with a dump/restore for now; I'll remove the user tables in question and run it through pg_upgrade again later this week. Thanks for the feedback. Regards, -- Glen Barber