Postgres Pro
Downloads
Home   >   mailing lists

Re: Do we want SYNONYMS? - Mailing list pgsql-general

From Andy Colson
Subject Re: Do we want SYNONYMS?
Date
Msg-id 4CFD401A.1050408@squeakycode.net
Whole thread Raw
In response to Do we want SYNONYMS?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Do we want SYNONYMS?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Do we want SYNONYMS?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Tree view 
On 12/6/2010 1:31 PM, Joshua D. Drake wrote:
> Hey -general,
>
> 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.
>
> Reference thread:
>
> http://archives.postgresql.org/pgsql-hackers/2010-11/msg02043.php
>
> Joshua D. Drake

I dont understand the need for it.  Dont view's do the exact same thing
(plus even more)?  What does a synonym offer that a view does not?

And perusing the thread, I see it might cause all name and operator
lookups to be slower?  (I didnt read all of it though)

I'm gonna have to go:  -1

-Andy

pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Do we want SYNONYMS?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Do we want SYNONYMS?