Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DEE1E6502D3 for ; Wed, 19 Nov 2008 19:21:33 -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 08278-02-7 for ; Wed, 19 Nov 2008 19:21:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by mail.postgresql.org (Postfix) with ESMTP id C982F6502B0 for ; Wed, 19 Nov 2008 19:17:19 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id j4so81905wah.19 for ; Wed, 19 Nov 2008 15:17:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=QjEgQIegzhAs4fTwVqPsT3czmgDBFX2snqnU4nzCYcQ=; b=MOtc28npUQSHqSGEMEEJcqCTgI4UMUpmSNfbzmRsFdpjsJ1mXPUOKGErOLQU+7yrgl 2/lZyfwrKBFyk5NKKXeV5/8UcNxPMC2c75q/tyZEZpV3teB5rtXj1gPw87GX6oP36f5w Tl9f5pQaHdiHAw4HSuAw9Klxpn67YwZepU/4Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=NafMCYskfCT8sFbTjlLtAmnK2/4jSTEOKUwQlspGcLNK7pBdTuxtfkoqkGGa7M4Smk yj6mPvCiaTgfTKfahORsLyv3vqAKHilV2wnPNDJE8QYkcAjIc8eNZ/W6y8tqd3IjXX42 giDX/+CGiHZzGmzKlEODEEzBxrSoH6xJ196OE= Received: by 10.114.94.12 with SMTP id r12mr944449wab.156.1227136637592; Wed, 19 Nov 2008 15:17:17 -0800 (PST) Received: by 10.114.133.14 with HTTP; Wed, 19 Nov 2008 15:17:17 -0800 (PST) Message-ID: Date: Wed, 19 Nov 2008 16:17:17 -0700 From: "Scott Marlowe" To: "Tim Gustafson" Subject: Re: Problems With pg_dumpall and OIDs Cc: pgsql-admin@postgresql.org In-Reply-To: <1772386216.39071227135939283.JavaMail.root@mail-01.cse.ucsc.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1772386216.39071227135939283.JavaMail.root@mail-01.cse.ucsc.edu> 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: 200811/121 X-Sequence-Number: 30775 On Wed, Nov 19, 2008 at 4:05 PM, Tim Gustafson wrote: >> A workaround: temporarily turn to "on" the value off the >> "default_with_oids" parameter in your configuration file >> (the defaults is "off"). > > I tried that, but still got warning messages about no OID columns when I imported the data into 8.2. :( Unless maybe I'm doing something wrong. I'm getting ready to "try again" shortly. Did you reload / restart postgrseql after making the change? When you psql into the server, what does show default_with_oids; say?