From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | pholben(at)greatbridge(dot)com, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Comments on Database Broken |
Date: | 2001-05-22 11:38:49 |
Message-ID: | 200105221138.f4MBcne28920@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Good analysis. Database comments are particularly tricky because
pg_description exists in every database, but is unique. To fix this, we
would need a global pg_description table that would be used _just_ for
database comments.
> Patricia Holben (pholben(at)greatbridge(dot)com) reports a bug with a
> severity of 3 The lower the number the more severe it is.
>
> Short Description Comments on Database Broken
>
> Long Description When comments are added to a database (testdb
> in this example) (either at the point of creation or using the
> "comment on database ..." command) they may be stored either at
> the system level or within the individual database storage area.
> Depending on how the user is connected, the "\l+" command may
> show the system comment on testdb (connected to template1 for
> example) OR the self-applied comment on testdb (connected to
> testdb) OR the local comment on testdb (connected to a different
> db which has made comments on what the other dbs are). When a
> pg_dumpall command is executed, the dbs are dropped, and then
> the dump file is reloaded, only the self-applied comments exist
> anymore. Mainly this is just confusing. Maybe they should only
> exist in the system area but be accessible to all.
>
> Sample Code
>
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to majordomo(at)postgresql(dot)org
> so that your message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Zagrebin | 2001-05-22 12:24:37 | bug in plpgsql??? |
Previous Message | Bruce Momjian | 2001-05-22 11:35:41 | Re: psql dumps core when entering invalid backslash command |