| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, Hans-J?rgen Sch?nig <postgres(at)cybertec(dot)at>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Glaesemann <grzm(at)myrealbox(dot)com>, pgsql-patches(at)postgresql(dot)org, eg(at)cybertec(dot)at |
| Subject: | Re: CREATE SYNONYM ... |
| Date: | 2006-03-07 21:43:50 |
| Message-ID: | 20060307134229.M47286@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
On Tue, 7 Mar 2006, Jim C. Nasby wrote:
> On Tue, Mar 07, 2006 at 12:39:55PM -0800, Stephan Szabo wrote:
> >
> > On Tue, 7 Mar 2006, Jonah H. Harris wrote:
> >
> > > On 3/7/06, Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:
> > > >
> > > > I'd personally be more interested in what the impact is on people not
> > > > using synonyms. How free is any search for synonyms if you aren't using
> > > > the feature?
> > >
> > >
> > > Unless synonym enablement were a configurable parameter (which wouldn't
> > > really make sense), the cost would be the same whether they're used or not
> > > during searching.
> >
> > Right, but the response was that "using" synonyms incurred a cost and this
> > should be documented. However, if there's a cost to people not using
> > synonyms there's a higher barrier to entry for the feature.
>
> Wouldn't the cost only be incurred if you searched for something in
> pg_class that wasn't there, and therefor had to fall back to pg_synonym?
I think if synonyms were search path dependant that wouldn't be true since
you'd need to know if there was a synonym that shadowed another item.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-07 22:14:48 | Re: CREATE SYNONYM ... |
| Previous Message | Jim C. Nasby | 2006-03-07 20:42:36 | Re: CREATE SYNONYM ... |