Re: [HACKERS] Another proposal for table synonyms

2010-12-03 Thread Alexey Klyukin
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-02 Thread Alvaro Herrera
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-02 Thread Robert Haas
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-02 Thread Alvaro Herrera
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-02 Thread Robert Haas
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'

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Csaba Nagy
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Alvaro Herrera
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Joshua D. Drake
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Dave Page
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Josh Berkus
>> 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? ;-) --

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Joshua D. Drake
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

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Josh Berkus
> 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

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Alexey Klyukin
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

Re: [HACKERS] Another proposal for table synonyms

2010-11-30 Thread Josh Berkus
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

Re: [HACKERS] Another proposal for table synonyms

2010-11-30 Thread Tom Lane
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.

Re: [HACKERS] Another proposal for table synonyms

2010-11-30 Thread Alexey Klyukin
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

Re: [HACKERS] Another proposal for table synonyms

2010-11-30 Thread Tom Lane
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

[HACKERS] Another proposal for table synonyms

2010-11-30 Thread Alexey Klyukin
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