Skip site navigation (1) Skip section navigation (2)

Re: Comments on Database Broken

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: (view raw, whole thread or download thread mbox)
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                        |
  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

In response to

pgsql-bugs by date

Next:From: Alexander ZagrebinDate: 2001-05-22 12:24:37
Subject: bug in plpgsql???
Previous:From: Bruce MomjianDate: 2001-05-22 11:35:41
Subject: Re: psql dumps core when entering invalid backslash command

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group