On Mar 4, 2009, at 6:07 PM, Josh Berkus wrote:
> Andrew,
>
>> Back on that track, I'd like to see a facility whereby we could
>> provide an alias (or synonym, to use a nearby subject) columns and
>> other objects. That would help to overcome naming glitches without
>> breaking things quite so much.
>
> Believe it or not, a large PostgreSQL user in LA just buttonholed me
> about that particular feature idea at SCALE. So it might be
> generally useful as well -- not just for the system catalogs, bug to
> allow businesses with long-use databases to manage change over time.
Schema change is a strong motivator for applications to access the
database through views and functions only. A column with multiple
names would likely make it *more* painful to migrate schemata.
Cheers,
M