> "Moray McConnachie" <moray.mcconnachie@computing-services.oxford.ac.uk> writes:
> > Agreed - but note that pg_dump currently produces CREATE INDEX
> > statements with opclasses included.
>
> Right, as it should since its purpose is to ensure you rebuild exactly
> the same database. I was just opining that handwritten CREATE INDEXes
> usually can omit the opclass. (BTW, I fixed the problem with functional
> indexes needing an explicit opclass spec last night.)
>
> > That means running a script created by pg_dump v.6.5.x will fail under
> > 7.0 because there is no index opclass of the type datetime?
>
> An embarrassing problem. We are going to work around this by having
> the 7.0 parser discard the word "datetime" if it sees it in the opclass
> position. There are a couple of other now-dead opclass names that will
> be discarded in the same way. Klugy, but it will get the job done for
> reading old dump files.
>
> (This hack is not in 7.0beta1, but will be in beta2.)
It is my understanding we are generating a new beta every night, so it
should be there now.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026