Re: introduce "default_use_oids" - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: introduce "default_use_oids"
Date
Msg-id Pine.LNX.4.44.0312020000290.23890-100000@peter.localdomain
Whole thread Raw
In response to Re: introduce "default_use_oids"  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: introduce "default_use_oids"
List pgsql-patches
Alvaro Herrera writes:

> On Mon, Dec 01, 2003 at 05:07:40PM -0500, Bruce Momjian wrote:
>
> > Neil Conway wrote:
> > > This patch adds a new GUC var, "default_use_oids", which follows the
> > > proposal for eventually deprecating OIDs on user tables that I posted
> > > earlier to pgsql-hackers. pg_dump now always specifies WITH OIDS or
> > > WITHOUT OIDS when dumping a table. The documentation has been updated.
> > >
> > > Comments are welcome.
>
> Hum, sorry to be late, but wasn't one of the supposed strenghts of
> pg_dump supposed to be that you could take a dump and load it on a
> different RDBMS?  I haven't tried it so I don't know if it works, but
> this patch takes out the ability to do that -- no one else will accept
> WITH/WITHOUT OIDS, so the dump will have to be modified.  Is a switch
> provided to stop the emission of those modifiers?

I agree with that.  By default, WITH/WITHOUT OIDS should not be dumped.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql: \dg and groups for \du
Next
From: Bruce Momjian
Date:
Subject: Re: psql: \dg and groups for \du