Re: [HACKERS] Re: Mirroring a DB

Karl DeBisschop <kdebisschop(at)range(dot)infoplease(dot)com> writes:
>> Current
>> sources will put table prefixes on every var in a rule if more than one
>> table appears in the rule's rangelist. I think this should be
>> sufficient, but it's hard to tell from this incomplete example;

> Version 6.5.3 seem to behave as you said, so I'm guessing that this
> fix occurred relatively recently and I was just unaware it had been
> fixed.

Actually, 6.5.3 just unconditionally prefixes all vars in a decompiled
rule, all the time. That was a quick-patch solution to the type of
problem you are complaining of. Current sources (6.6/7.0-to-be) try to
be smarter by only prefixing vars when there is possible ambiguity (ie,
more than one table in the rangelist). That's why I was concerned about
the details of your example --- I was wondering if this "improvement"
might fail under the right special case...

regards, tom lane