Re: COMMENT ON [GROUP/USER]

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: COMMENT ON [GROUP/USER]
Date: 2004-03-08 21:18:31
Message-ID: 404CE327.5070901@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor wrote:

>On Mon, 2004-03-08 at 14:46, Andrew Dunstan wrote:
>
>
>>Bruce Momjian wrote:
>>
>>
>>
>>>Another problem is that pg_description is per-database, while
>>>pg_user/group are global for all databases.
>>>
>>>
>>>
>>>
>>>
>>databases are also per cluster, but we have comments on those.
>>
>>Could we keep the user/group comments in those tables instead of in
>>pg_description?
>>
>>
>
>Comments longer than ~7k would need a toast table. At the moment, toast
>tables don't work on a global basis.
>
>
>

Well, presumably we don't want to keep their life story ;-)

I was just thinking out loud I guess - I see there are wrinkles I hadn't
considered.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-03-08 21:24:30 Re: COMMENT ON [GROUP/USER]
Previous Message scott.marlowe 2004-03-08 21:16:36 Re: question about selecting across multiple dbs