

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] 
> Sent: 11 September 2002 18:21
> To: Oliver Elphick
> Cc: Dave Page; Tom Lane; Lamar Owen; Philip Warner; Laurette 
> Cisneros; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS]
> 
> 
> Oliver Elphick wrote:
> > But now we should be telling people to use 7.3's 
> pg_dumpall, at least 
> > for 7.2 data.  (How far back can it go?)
> > 
> >         Make sure you use pg_dumpall from the new 7.3 
> software to dump
> >         your data from 7.2.  To do this, you must have the 7.2
> >         postmaster running and run the 7.3 pg_dumpall by 
> using its full
> >         pathname.  7.2's pg_dumpall is unsuitable because of the
> >         introduction of schemas in 7.3 which make it 
> necessary to grant
> >         public access to features that will, if created 
> from a 7.2 dump,
> >         be given access by their owner only.
> 
> That's a pretty big hurtle.  I think we are better off giving 
> them an SQL UPDATE to run.

How would that massage a dump file though? I can't think of any SQL that
might make 7.2 output 'language_handler' correctly, and we already know
7.3 will barf on opaque.

Regards, Dave.

Wed, 11 Sep 2002 22:09:59 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Re: 
Dave Page wrote:
> > That's a pretty big hurtle.  I think we are better off giving 
> > them an SQL UPDATE to run.
> 
> How would that massage a dump file though? I can't think of any SQL that
> might make 7.2 output 'language_handler' correctly, and we already know
> 7.3 will barf on opaque.

Oh, I thought it was just the permissions that were the problem.  Can we
give them a sed script?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Wed, 11 Sep 2002 17:13:04 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: 