Re: CREATE SYNONYM ... - Mailing list pgsql-patches

From Jonah H. Harris
Subject Re: CREATE SYNONYM ...
Date
Msg-id 36e682920603090746t34c56de9la16c411bf1312db4@mail.gmail.com
Whole thread Raw
In response to Re: CREATE SYNONYM ...  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-patches
On 3/8/06, Stephan Szabo <sszabo@megazone.bigpanda.com> wrote:
You responded with a statement about synonyms having cost in response to a
message of mine in response to a message from postgres@cybertec.at which
said "the costs will only be added if the "real table" is not found.
therefore there is no impact on "normal" users." Your idea and that of the
person who submitted this patch thus seem to be slightly different.

Yes, this is something that Hans and I would discuss about the patch.

I'd rather the feature follows the model you
described (although I may have greater concerns of the cost) because it
seems consistent with other lookups.

This is correct, for a synonym to be added, the cost for 1 synonym would be the same as adding 1 more table/function/view/etc depending on the catalog you're searching; I don't think it's too costly.  I'm going to start a new thread to propose this clearly.





--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

pgsql-patches by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: [HACKERS] Automatic free space map filling
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: Fix overflow of bgwriter's request queue