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

Re: Another proposal for table synonyms

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Alexey Klyukin <alexk(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Another proposal for table synonyms
Date: 2010-11-30 20:05:07
Message-ID: 4CF558F3.8070907@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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?

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?

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

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

In response to

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2010-11-30 20:09:31
Subject: Where are we on Standby Promotion?
Previous:From: Yeb HavingaDate: 2010-11-30 19:57:39
Subject: Re: Fix for seg picksplit function

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