Re: COMMENT ON [GROUP/USER] - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: COMMENT ON [GROUP/USER]
Date
Msg-id 404CE327.5070901@dunslane.net
Whole thread Raw
In response to Re: COMMENT ON [GROUP/USER]  (Rod Taylor <pg@rbt.ca>)
List 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


pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Re: COMMENT ON [GROUP/USER]
Next
From: Tom Lane
Date:
Subject: Re: COMMENT ON [GROUP/USER]