On Dec 3, 2010, at 2:17 AM, Alvaro Herrera wrote:
> Excerpts from Robert Haas's message of jue dic 02 21:10:48 -0300 2010:
>> On Thu, Dec 2, 2010 at 3:43 PM, Alvaro Herrera
>> wrote:
>>> Excerpts from Robert Haas's message of jue dic 02 17:27:01 -0300 2010:
>
>>> Yeah, the Oracle system is a lo
Excerpts from Robert Haas's message of jue dic 02 21:10:48 -0300 2010:
> On Thu, Dec 2, 2010 at 3:43 PM, Alvaro Herrera
> wrote:
> > Excerpts from Robert Haas's message of jue dic 02 17:27:01 -0300 2010:
> > Yeah, the Oracle system is a lot more complex than SQL Server's, but I
> > was only talki
On Thu, Dec 2, 2010 at 3:43 PM, Alvaro Herrera
wrote:
> Excerpts from Robert Haas's message of jue dic 02 17:27:01 -0300 2010:
>> On Wed, Dec 1, 2010 at 3:55 PM, Alvaro Herrera
>> wrote:
>> > Excerpts from Josh Berkus's message of mié dic 01 17:13:35 -0300 2010:
>> >>
>> >> > Well, porting applic
Excerpts from Robert Haas's message of jue dic 02 17:27:01 -0300 2010:
> On Wed, Dec 1, 2010 at 3:55 PM, Alvaro Herrera
> wrote:
> > Excerpts from Josh Berkus's message of mié dic 01 17:13:35 -0300 2010:
> >>
> >> > Well, porting applications from other database systems that support
> >> > synony
On Wed, Dec 1, 2010 at 3:55 PM, Alvaro Herrera
wrote:
> Excerpts from Josh Berkus's message of mié dic 01 17:13:35 -0300 2010:
>>
>> > Well, porting applications from other database systems that support
>> > synonyms
>> > (i.e. Oracle, DB2, SQL Server).
>>
>> SQL Server supports synonyms? If it'
Hi all,
On Tue, 2010-11-30 at 12:05 -0800, Josh Berkus wrote:
> Can you explain, for our benefit, the use case for this? Specifically,
> what can be done with synonyms which can't be done with search_path and
> VIEWs?
I had a few cases where synonyms for user/data base names would have
helped me
Excerpts from Josh Berkus's message of mié dic 01 17:13:35 -0300 2010:
>
> > Well, porting applications from other database systems that support synonyms
> > (i.e. Oracle, DB2, SQL Server).
>
> SQL Server supports synonyms? If it's not Oracle-only, it's a more
> powerful argument to have the fea
On Wed, 2010-12-01 at 12:46 -0800, Josh Berkus wrote:
> >> I'd love to hear from someone at EDB: how are you dealing with synonym
> >> name collisions right now?
> >
> > I think the way we deal with that is the way PostgreSQL deals with it.
> > Unique names per search path.
>
> Have you had an em
On Wed, Dec 1, 2010 at 8:46 PM, Josh Berkus wrote:
>
>>> I'd love to hear from someone at EDB: how are you dealing with synonym
>>> name collisions right now?
>>
>> I think the way we deal with that is the way PostgreSQL deals with it.
>> Unique names per search path.
>
> Have you had an employmen
>> I'd love to hear from someone at EDB: how are you dealing with synonym
>> name collisions right now?
>
> I think the way we deal with that is the way PostgreSQL deals with it.
> Unique names per search path.
Have you had an employment change I didn't know about, JD? ;-)
--
On Wed, 2010-12-01 at 12:13 -0800, Josh Berkus wrote:
> > Well, porting applications from other database systems that support synonyms
> > (i.e. Oracle, DB2, SQL Server).
>
> SQL Server supports synonyms? If it's not Oracle-only, it's a more
> powerful argument to have the feature.
Oracle, DB2 a
> Well, porting applications from other database systems that support synonyms
> (i.e. Oracle, DB2, SQL Server).
SQL Server supports synonyms? If it's not Oracle-only, it's a more
powerful argument to have the feature.
(IMHO, the main reason why Oracle has synonyms is that their
implementation
On Nov 30, 2010, at 10:05 PM, Josh Berkus wrote:
> Alexey,
>
>> Here is the proposal to add synonyms to PostgreSQL. Initial goal is to add
>> synonyms
>> for relations (tables, views, sequences) and an infrastructure to allow
>> synonyms
>> for other database objects in the future.
>
> Can y
Alexey,
> Here is the proposal to add synonyms to PostgreSQL. Initial goal is to add
> synonyms
> for relations (tables, views, sequences) and an infrastructure to allow
> synonyms
> for other database objects in the future.
Can you explain, for our benefit, the use case for this? Specificall
Alexey Klyukin writes:
> On Nov 30, 2010, at 6:28 PM, Tom Lane wrote:
>> This is not going to work, at least not without making every type of
>> lookup consult pg_synonym too, which I think can be considered DOA
>> because of its performance impact on people who aren't even using the
>> feature.
On Nov 30, 2010, at 6:28 PM, Tom Lane wrote:
> Alexey Klyukin writes:
>> To support addition of new database objects types that can be referenced by
>> synonyms a new system catalog, pg_synonym, is to be added, with an oid to
>> support comments on synonym, and the following schema:
>
> This is
Alexey Klyukin writes:
> To support addition of new database objects types that can be referenced by
> synonyms a new system catalog, pg_synonym, is to be added, with an oid to
> support comments on synonym, and the following schema:
This is not going to work, at least not without making every ty
Hello,
Here is the proposal to add synonyms to PostgreSQL. Initial goal is to add
synonyms
for relations (tables, views, sequences) and an infrastructure to allow synonyms
for other database objects in the future.
A thread with discussion of an old proposal by Jonah Harris is here:
http://arch
18 matches
Mail list logo