Re: Killing OIDs

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Killing OIDs
Date: 2009-02-11 19:48:58
Message-ID: 49932BAA.2060702@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2009-02-11 19:59:22 Re: Killing OIDs
Previous Message Scott Marlowe 2009-02-11 19:40:50 Re: Killing OIDs