Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Oh, what I normally do is to look at regression.diff, and if that looks > > OK, I just apply it to the expected file like this: > > > cd expected > > patch < ../regression.diff > > Oh, that explains a few things ... > > It's much better to just copy the result file over the expected file > once you've decided it's OK. The regression.diff file is inexact > because of the diff switches that are used.
I am confused. patch dosen't make an indentical file? Example? > If you need to update expected variants your machine doesn't generate, > make a fresh regular diff off the expected and actual, and apply that > to the other variants. Ah, good point. I often forget about those. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
