Skip site navigation (1) Skip section navigation (2)

Re: Another proposal for table synonyms

From: Alexey Klyukin <alexk(at)commandprompt(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Another proposal for table synonyms
Date: 2010-12-01 19:46:48
Message-ID: 6BC0F0BC-E9B0-43CE-89E1-8FA97A625B82@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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 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?

Well, porting applications from other database systems that support synonyms
(i.e. Oracle, DB2, SQL Server).

> 
> I ask partly because I've migrated some Oracle databases to PostgreSQL,
> and did not find replacing the functionality of synonyms to be at all
> difficult.  Presumably you've run into a case which was difficult?

Frankly, I don't have a specific use case, but there were some requests in
this list asking for synonyms, and adding support for them is a TODO item in
wiki.

> 
> BTW, I have a specific use case for *column* synonyms which isn't
> currently covered by our existing tools.

Is this the feature the community would benefit from? We can consider adding
column synonyms if we won't hardwire synonyms to pg_class objects.

--
Alexey Klyukin				    http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc


In response to

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2010-12-01 20:13:35
Subject: Re: Another proposal for table synonyms
Previous:From: Peter EisentrautDate: 2010-12-01 19:19:03
Subject: Re: DELETE with LIMIT (or my first hack)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group