| From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Proposal for SYNONYMS |
| Date: | 2006-03-09 21:42:43 |
| Message-ID: | 36e682920603091342t5228cd8er3c727ffb752991e0@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 3/9/06, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
> 1) Is there a SQL standard for this?
Nope.
2) For my comprehension, what's the difference between a SYNONYM and a
> single-object (possibly updatable) view?
Not a whole lot actually. If we had updateable views, I'd suggest that
people change their create synonym syntax to create view. However, it would
take substantially more work to implement updatable views than synonyms and
the functionality of updatable views is substantially different than the use
of synonyms alone. If/when updatable views are implemented, I wouldn't have
a problem switching create synonym to actually create a view.
--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2006-03-09 21:50:20 | Re: Coverity Open Source Defect Scan of PostgreSQL |
| Previous Message | Josh Berkus | 2006-03-09 21:33:09 | Re: Proposal for SYNONYMS |