From: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com> |
---|---|
To: | jd(at)commandprompt(dot)com |
Cc: | Andy Colson <andy(at)squeakycode(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Do we want SYNONYMS? |
Date: | 2010-12-06 20:23:15 |
Message-ID: | AANLkTing=8HfTGgZz4gwvwbEm5s24_Nc181rURpKf1=L@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What is synonym? Is it a reference? Can I dump DDL of the object
by synonym? If no, I personally don't see how it can be used.
Maybe it can be used to create 7 synonyms for some table and let
application use different synonym depends on day of the week... :-)
I don't see how it can be used...
2010/12/6 Joshua D. Drake <jd(at)commandprompt(dot)com>
> On Mon, 2010-12-06 at 13:57 -0600, Andy Colson wrote:
> > 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?
>
> SYNONYMS work for things that aren't a table.
>
> JD
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
> Consulting, Training, Support, Custom Development, Engineering
> http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
// Dmitriy.
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitriy Igrishin | 2010-12-06 20:26:45 | Re: Do we want SYNONYMS? |
Previous Message | Michael C Rosenstein | 2010-12-06 20:13:25 | Re: Do we want SYNONYMS? |