> -----Original Message-----
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: 11 September 2002 18:21
> To: Oliver Elphick
> Cc: Dave Page; Tom Lane; Lamar Owen; Philip Warner; Laurette
> Cisneros; [EMAIL PROTECTED]
> 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.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
