Re: Killing OIDs - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Killing OIDs
Date
Msg-id 49932BAA.2060702@iol.ie
Whole thread Raw
In response to Re: Killing OIDs  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Killing OIDs
List pgsql-general
On 11/02/2009 19:40, Scott Marlowe wrote:

> Since 8.3 creates tables WITHOUT OIDS by default, I'd think just
> dumping from 7.4 to 8.3 with 8.3's pg_dump should do the trick.  Or am
> I missing something?

I could be wrong, but I think 8.3's pg_dump will append WITH (OIDS=TRUE)
if it finds tables with OIDs.

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Killing OIDs
Next
From: Steve Crawford
Date:
Subject: Re: Killing OIDs