Re: Killing OIDs

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
------------------------------------------------------------------