db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: [PATCH] Synonym support in Derby.
Date Wed, 01 Jun 2005 23:02:56 GMT
Satheesh Bandaram wrote:

> Hi
> 
> I am attaching a patch that adds SYNONYM support to Derby.  Synonym
> provides an alternate name for a table or a view that is present in the
> same schema or another schema. A synonym can also be created for another
> synonym, causing nesting of synonyms. A synonym can be used in SELECT,
> INSERT, UPDATE, DELETE or LOCK TABLE statements instead of the original
> qualified table or view name. Note that a synonym can be created for a
> table or a view that doesn't yet exists. But the target table/view must
> be present before the synonym can be used.

[snip]

> Let me know if you have any comments or suggestions. My vote is *+1*, to
> accept this patch.

Any explanation of how SYNONYMs are implemented? You had indicated a
couple of days ago you were undecided on how to represent them in system
catalogs.

Is the namespace for SYNONYM the same as for tables, or separate? If
separate and A.B is both a table name and a synoymn name, which is selected?

Dan.


Mime
View raw message