Skip site navigation (1) Skip section navigation (2)

Re: synonym

From: "Medi Montaseri" <montaseri(at)gmail(dot)com>
To: s(dot)borse(at)direction(dot)biz
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: synonym
Date: 2007-12-14 07:50:13
Message-ID: 8078a1730712132350n4ebc2cd3n5824387ad208cc85@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
PostgreSQL does not support SYNOSYM or ALIAS. Synonym is a non SQL 2003
feature implemented by Microsoft SQL 2005 (I think). While it does provide
an interesting abstraction, but due to lack of relational integrity, it can
be considered a risk.

That is, you can create a synonym, advertise it to you programmers, the code
is written around it, including stored procedures, then one day the backend
of this synonym (or link or pointer) is changed/deleted/etc leading to a run
time error. I don't even think a prepare would catch that.

It is the same trap as the symbolic links in unix and null pointers in
C/C++.

Cheers
Medi

On Dec 13, 2007 10:39 PM, DBA <s(dot)borse(at)direction(dot)biz> wrote:

>  Hi,
>
> Is it possible to create synonym in postgresql?
>
> I am getting error while creating synonym.
>
> ERROR:  syntax error at or near "synonym" at character 8
>
>
>
> Thanks & Regards,
> Suresh
>
>
>

In response to

  • synonym at 2007-12-14 06:39:49 from DBA

Responses

  • Re: synonym at 2007-12-17 02:10:30 from Bruce Momjian

pgsql-admin by date

Next:From: Pedram MDate: 2007-12-14 08:38:58
Subject: Re: server error
Previous:From: DBADate: 2007-12-14 06:39:49
Subject: synonym

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group