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

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.borse@direction.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
>
>
>

Medi Montaseri wrote:
> 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++.

It is on the TODO:

* Add support for public SYNONYMs

http://archives.postgresql.org/pgsql...3/msg00519.php

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate