Re: SYNONYMs revisited

On Wed, Mar 04, 2009 at 10:14:41AM -0500, Jonah H. Harris wrote:
>    SQL/MED does support foreign tables, which are basically synonyms for
>    remote tables.  Other than that, it has no real similarity to synonym
>    behavior for other database objects such as views, functions, or local
>    tables.

I didn't mean to suggest that SQL/MED on its own could be used to make
SYNONYMs, but rather that given SQL/MED, perhaps we could reconsider
some sort of CREATE SYNONYM functionality to go along with it. A major
argument against CREATE SYNONYM in the past was that we wouldn't be able
to create synonyms representing remote objects because we couldn't
access remote objects. With SQL/MED that's no longer the case, so
perhaps that argument no longer applies.

- Josh / eggyknap