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