Addition of alias types regpublication and regsubscription

Поиск
Список
Период
Сортировка
От vignesh C
Тема Addition of alias types regpublication and regsubscription
Дата
Msg-id CALDaNm27iKiOSODjudjfSZ4kPfnhwqWricWrgm9U7Oiv4S62mw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Addition of alias types regpublication and regsubscription  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

I felt inclusion of alias types regpublication and regsubscription will help the logical replication users. This will also help in [1].
The alias types allow simplified lookup of publication oid values for objects. For example, to examine the pg_publication_rel rows, one could write:
SELECT prpubid::regpublication, prrelid::regclass FROM pg_publication_rel;

rather than:
SELECT p.pubname, prrelid::regclass FROM pg_publication_rel pr, pg_publication p WHERE pr.prpubid = p.oid;

Similarly in case of subscription:
For example, to examine the pg_subscription_rel rows, one could write:
SELECT srsubid::regsubscription, srrelid::regclass FROM pg_subscription_rel;

rather than:
SELECT s.subname,srsubid::regclass FROM pg_subscription_rel sr, pg_subscription s where sr.srsubid = s.oid;

Attached patch has the changes for the same.
Thoughts?

[1] - https://www.postgresql.org/message-id/flat/CALDaNm0OANxuJ6RXqwZsM1MSY4s19nuH3734j4a72etDwvBETQ%40mail.gmail.com

Regards,
Vignesh
Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: be-secure-gssapi.c and auth.c with setenv() not compatible on Windows
Следующее
От: vignesh C
Дата:
Сообщение: Re: CREATE COLLATION - check for duplicate options and error out if found one