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

Re: CREATE SYNONYM ...

From: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,"Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>,"Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>,Michael Glaesemann <grzm(at)myrealbox(dot)com>,pgsql-patches(at)postgresql(dot)org, eg(at)cybertec(dot)at
Subject: Re: CREATE SYNONYM ...
Date: 2006-03-08 07:26:46
Message-ID: 440E8736.3070709@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-patches
> What I don't really understand is what part of this cannot be achieved
> by changing the search_path.  The only case I can think of is when you
> have tables A and B in schemas R and S, but you want to use R.A and S.B.
> So there's no way to change search_path for this.  But is this really
> the intended use case?

yes, this is a very practical case ...


> I wonder whether synonyms were introduced in Oracle because of that idea
> of theirs that each user has its own schema, and can access that schema
> only; so to use a table in another schema you need to create a synonym.
> We don't have that limitation so we don't need that usage either.


i am sure this was a reason but not the only one.
some other reason could be (again, bad but widespread): somebody defined 
a bad data structure where everything is in separate tables (tom's cars 
are in table A, bruce's cars are in table B). somebody finally finds out 
that this was a bad idea (3mio lines of code were built on top of this 
crap) and that those tables should be combined. a synonym will help.
just think of broken applications such as SAP - everything is in a 
separate table (maybe they have 100000000000000 which only stored 
desciptions), if you want to cleanup a synonym is less error prone than 
'sed -e ...'.

if synonyms are a broken concept then the same would apply for softlinks 
and hardlinks supported by filesystem - still people like soft/hardlinks 
and they are widely adopted because they are useful. of course, you can 
live without file systems links if you can afford changing the path 
after every line of shell code.

	best regards,

		hans


-- 
Cybertec Geschwinde & Schönig GmbH
Schöngrabern 134; A-2020 Hollabrunn
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at

In response to

pgsql-patches by date

Next:From: Hans-Jürgen SchönigDate: 2006-03-08 07:29:06
Subject: Re: CREATE SYNONYM ...
Previous:From: Hans-Jürgen SchönigDate: 2006-03-08 07:20:33
Subject: Re: CREATE SYNONYM ...

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