Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

Bruce,

* Bruce Momjian (bruce@momjian.us) wrote:
> Robert Haas wrote:
> > > In a way, the fact that the restore fails can be seen as a feature ---
> > > they get the error before the go live on 8.4. ?(Yeah, I am serious.)
> >=20
> > Eeh, I've had this happen to me on earlier releases, and it didn't
> > feel like a feature to me.  YMMV, of course.
>=20
> Would you have preferred later application failure?

If it's an option w/ a default of "off", then chances are the admin will
get the failure you're talking about, realize there's an issue, but then
have a way to actually *fix* the restore without having to hack up
multi-gigabyte files using vi.  If you'd like, you're welcome to
consider the default of "off" as a feature.

+1 from me for adding the option.

    Thanks,

        Stephen