Re: CREATE SYNONYM ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CREATE SYNONYM ...
Дата
Msg-id 20247.1142353777@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CREATE SYNONYM ...  (Hans-Jürgen Schönig <postgres@cybertec.at>)
Ответы Re: CREATE SYNONYM ...  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-patches
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres@cybertec.at> writes:
> Peter Eisentraut wrote:
>> Does any SQL-like database system other than Oracle have this feature?

> the most popular are: db2, max db, informix, ms sql.
> in other words: all databases which are widely used and widely accepted.

That argument only holds water if they all support it with the same
semantics, a fact not in evidence.  I'm not impressed by whether they
all have things they call synonyms, unless they all work alike.  What
are their approaches to permissions?  What happens if the referenced
object is dropped or modified?  Can you make a synonym to something that
doesn't exist yet?  What sorts of objects can have synonyms?

            regards, tom lane

В списке pgsql-patches по дате отправления:

Предыдущее
От: Hans-Jürgen Schönig
Дата:
Сообщение: Re: CREATE SYNONYM ...
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: CREATE SYNONYM ...