Re: pg_create_logical_replication_slot returns text instead of name - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: pg_create_logical_replication_slot returns text instead of name
Date
Msg-id CAD21AoDVyqxstjsoCA=qehVQ+Ms4fC8av8m_vLm_N46o+tWnDw@mail.gmail.com
Whole thread Raw
In response to Re: pg_create_logical_replication_slot returns text instead of name  (Michael Paquier <michael@paquier.xyz>)
Responses Re: pg_create_logical_replication_slot returns text instead of name  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Fri, Jul 13, 2018 at 9:48 AM, Michael Paquier <michael@paquier.xyz> wrote:
> On Thu, Jul 12, 2018 at 10:18:53PM +0900, Michael Paquier wrote:
>> That's a small thing, but I agree with you.  As far as I can see slot
>> names are always mapped with the name type.  I'll push that tomorrow if
>> there are no objections.
>
> Pushed, with a catalog version bump.
>

Thank you!

> While double-checking things, I have noticed that pg_stat_wal_receiver
> also uses text for slot names.  I am not sure if this one is worth
> bothering as the docs point out the correct type, just mentioning.

Hmm, I'm also not sure about the policy of usage of name data type for
columns that show an object identifier on external servers. There is a
similar case; we have the pubname in pg_subscritpion as name type
whereas the subpublications in pg_subscription is text[] type.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: ON CONFLICT DO NOTHING on pg_dump
Next
From: "Imai, Yoshikazu"
Date:
Subject: RE: Locking B-tree leafs immediately in exclusive mode