Thread: Comment on database
Restrict comment to the current database in order to prevent them from mysteriously disappearing. ie. \d+ will only ever show the comment for the current database -- which is appropriate since it can only pull comments from the current database. Won't break pgadmin functionality as it enforces this behaviour already. I didn't find any regression tests for COMMENT.
Attachment
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Rod Taylor wrote:
> Restrict comment to the current database in order to prevent them from
> mysteriously disappearing.
>
> ie. \d+ will only ever show the comment for the current database --
> which is appropriate since it can only pull comments from the current
> database.
>
> Won't break pgadmin functionality as it enforces this behaviour already.
>
>
> I didn't find any regression tests for COMMENT.
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Patch applied. Thanks. --------------------------------------------------------------------------- Rod Taylor wrote: > Restrict comment to the current database in order to prevent them from > mysteriously disappearing. > > ie. \d+ will only ever show the comment for the current database -- > which is appropriate since it can only pull comments from the current > database. > > Won't break pgadmin functionality as it enforces this behaviour already. > > > I didn't find any regression tests for COMMENT. [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026