Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M38332=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1ZRBX7-0002Jl-OC
 for pgsql-sql@arkaria.postgresql.org; Mon, 17 Aug 2015 03:56:25 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-sql-owner+M38332=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1ZRBX7-0007Eb-Ao
 for pgsql-sql@arkaria.postgresql.org; Mon, 17 Aug 2015 03:56:25 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <sfbarbee@gmail.com>) id 1ZRBX6-0007Dz-Ef
 for pgsql-sql@postgresql.org; Mon, 17 Aug 2015 03:56:24 +0000
Received: from mail-pa0-x22b.google.com ([2607:f8b0:400e:c03::22b])
 by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <sfbarbee@gmail.com>) id 1ZRBX3-0002qj-S3
 for pgsql-sql@postgresql.org; Mon, 17 Aug 2015 03:56:23 +0000
Received: by pabyb7 with SMTP id yb7so99057489pab.0
 for <pgsql-sql@postgresql.org>; Sun, 16 Aug 2015 20:56:19 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=subject:to:references:cc:from:message-id:date:user-agent
 :mime-version:in-reply-to:content-type:content-transfer-encoding;
 bh=c6ofd0yYXOSSOnCNbcNZZytVoZ3bJcNnbIL+lF25JBo=;
 b=QVijYjbzHQNkcDg7gT8lfdBohOrrOudtxNJ9btjMAqaUA6h6huhL6JRj4rAFwJsK1/
 SPacB2Pngv0YSEtqdwQVhn6r2AFbwwuxlfBVIm6ecyfgQpdkiDEW1mX7Pkjf2SHVZwJa
 nTL+UCPDGpilPxpZWGftyss9W6kZZ7Zg2p4VfOoAbkdBJkPV9gZjaGsMBHofBB7BDPPa
 mSMkzHqf02ZDlTytunGPUgJm6NruQr9uuDJvgfhYEjm/2Yzqm+eVVQLSpprVK4tCqAt5
 yuHoaMMlAGVimDUrcLpXP4CyvnpP4RXSVRm6BP3akWIwFv5lsIrx1bH9ww9YmJsesVho
 mKKQ==
X-Received: by 10.68.191.130 with SMTP id gy2mr64096113pbc.124.1439783779403;
 Sun, 16 Aug 2015 20:56:19 -0700 (PDT)
Received: from station12.ousa.org (nat-198-95-226-236.netapp.com.
 [198.95.226.236])
 by smtp.googlemail.com with ESMTPSA id i7sm12838794pdo.84.2015.08.16.20.56.17
 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
 Sun, 16 Aug 2015 20:56:18 -0700 (PDT)
Subject: Re: ERROR: cache lookup failed for type
To: Tom Lane <tgl@sss.pgh.pa.us>
References: <55D131B0.6010500@gmail.com> <15241.1439781395@sss.pgh.pa.us>
 <55D15A62.70406@gmail.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: Stuart <sfbarbee@gmail.com>
X-Enigmail-Draft-Status: N1110
Message-ID: <55D15B5F.30406@gmail.com>
Date: Mon, 17 Aug 2015 07:56:15 +0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
In-Reply-To: <55D15A62.70406@gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Tom, forgot to include the rest of the platform info.

This on openSuSE Linux 13.2 x86_64, kernel 4.1.4

On 08/17/2015 07:52 AM, Stuart wrote:
> 
>> Does reindexing pg_type make the error go away?  If so, what platform
>> and filesystem is this on?

Thanks,

Stuart




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