From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tim Gustafson <tjg@soe.ucsc.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Problems With pg_dumpall and OIDs
Date: Wed, 19 Nov 2008 16:17:17 -0700
Message-ID: <dcc563d10811191517y41e069b1q8f00fb456ee5f523@mail.gmail.com> (raw)
In-Reply-To: <1772386216.39071227135939283.JavaMail.root@mail-01.cse.ucsc.edu>
References: <gg254a$tjp$1@ger.gmane.org>
<1772386216.39071227135939283.JavaMail.root@mail-01.cse.ucsc.edu>
On Wed, Nov 19, 2008 at 4:05 PM, Tim Gustafson <tjg@soe.ucsc.edu> 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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, tjg@soe.ucsc.edu
Subject: Re: Problems With pg_dumpall and OIDs
In-Reply-To: <dcc563d10811191517y41e069b1q8f00fb456ee5f523@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox