Re: patch: Allow \dd to show constraint comments

Поиск
Список
Период
Сортировка
От Kohei KaiGai
Тема Re: patch: Allow \dd to show constraint comments
Дата
Msg-id BANLkTi=YBCZ3OzqOCoJ-nP6cnNTiVz7Gqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: patch: Allow \dd to show constraint comments  (Josh Kupershmidt <schmiddy@gmail.com>)
Ответы Re: patch: Allow \dd to show constraint comments
Список pgsql-hackers
I think the v5 patch should be marked as 'Ready for Committer'

2011/6/18 Josh Kupershmidt <schmiddy@gmail.com>:
> On Sat, Jun 18, 2011 at 10:53 AM, Kohei KaiGai <kaigai@kaigai.gr.jp> wrote:
>> In addition, this pg_comments system view supports 'access method' class, but
>> we cannot set a comment on access methods using COMMENT ON statement.
>
> Well, there are comments for the built-in access methods, i.e.
>
Oops, I missed the comments on initdb stage.

>> Regarding to the data-type of objnamespace, how about an idea to define a new
>> data type such as 'regschema' and cast objnamespace into this type?
>> If we have such data type, user can reference string expression of schema name,
>> and also available to use OID joins.
>
> Are you suggesting we leave the structure of pg_comments unchanged,
> but introduce a new 'regschema' type so that if users want to easily
> display the schema name of an object, they can just do:
>
>  SELECT objnamespace::regschema, ...
>    FROM pg_comments WHERE ... ;
>
> That seems reasonable to me.
>
Yes, however, it should be discussed in another thread as Robert said.

Thanks,
--
KaiGai Kohei <kaigai@kaigai.gr.jp>


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: SSI tuning points
Следующее
От: Kohei KaiGai
Дата:
Сообщение: Re: [v9.2] DROP Reworks Part.0 - 'missing_ok' support of get_object_address