Re:

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