Re: Do we want SYNONYMS?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: jd(at)commandprompt(dot)com
Cc: Vick Khera <vivek(at)khera(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Do we want SYNONYMS?
Date: 2010-12-07 19:07:20
Message-ID: 4CFE85E8.8070206@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/07/2010 10:45 AM, Joshua D. Drake wrote:
> On Tue, 2010-12-07 at 08:31 -0500, Vick Khera wrote:
>> On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake<jd(at)commandprompt(dot)com> wrote:
>>> Command Prompt is currently considering writing a patch to provide
>>> synonyms to PostgreSQL. Is this something the community is interested
>>> in? Do we have use cases for it? MSSQL, DB2 and Oracle support them.
>>>
>>
>> I must be missing something, but really, what's the point of synonyms?
>> What's the real-world use case for them?
>
> For a PostgreSQL Person? I see no real benefit to be honest. For people
> coming from Oracle, DB2 or MSSQL? I see a real benefit in terms of ease
> of porting.
>
> I asked on the Oracle free list[1] and Synonyms are used and used a lot
> in Oracle. Anything we can do to help those folks run screaming from
> err.... port to PostgreSQL seems like a good idea. (Assuming we can do
> it reasonably)
>
> Sincerely,
>
> Joshua D. Drake

If I am following this thread correctly the biggest issue to date is
getting an apple to apple comparison. The confusion seems to be that
what is proposed for SYNONYMS in Pg is not actually a synonym for
SYNONYMS in Oracle.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-12-07 19:17:35 Re: Do we want SYNONYMS?
Previous Message Gary Chambers 2010-12-07 19:03:42 Re: Tool for data modeling and ER diagram