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
On Dec 13, 2007 10:39 PM, DBA <s(dot)borse(at)direction(dot)biz> wrote:
> 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,
In response to
- synonym at 2007-12-14 06:39:49 from DBA
pgsql-admin by date
|Next:||From: Pedram M||Date: 2007-12-14 08:38:58|
|Subject: Re: server error|
|Previous:||From: DBA||Date: 2007-12-14 06:39:49|