Addition of alias types regpublication and regsubscription
Hi,
I felt inclusion of alias types regpublication and regsubscription will
help the logical replication users. This will also help in [1]/messages/by-id/CALDaNm0OANxuJ6RXqwZsM1MSY4s19nuH3734j4a72etDwvBETQ@mail.gmail.com.
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]: /messages/by-id/CALDaNm0OANxuJ6RXqwZsM1MSY4s19nuH3734j4a72etDwvBETQ@mail.gmail.com
/messages/by-id/CALDaNm0OANxuJ6RXqwZsM1MSY4s19nuH3734j4a72etDwvBETQ@mail.gmail.com
Regards,
Vignesh
vignesh C <vignesh21@gmail.com> writes:
I felt inclusion of alias types regpublication and regsubscription will
help the logical replication users.
This doesn't really seem worth the trouble --- how often would you
use these?
If we had a policy of inventing reg* aliases for every kind of catalog
object, that'd be one thing, but we don't. (And the overhead in
inventing new object kinds is already high enough, so I'm not in favor
of creating such a policy.)
regards, tom lane
On Sat, May 29, 2021 at 9:10 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
vignesh C <vignesh21@gmail.com> writes:
I felt inclusion of alias types regpublication and regsubscription will
help the logical replication users.This doesn't really seem worth the trouble --- how often would you
use these?If we had a policy of inventing reg* aliases for every kind of catalog
object, that'd be one thing, but we don't. (And the overhead in
inventing new object kinds is already high enough, so I'm not in favor
of creating such a policy.)
ok, Thanks for considering this.
Regards,
Vignesh