| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: shared description table. |
| Date: | 2006-02-12 03:22:02 |
| Message-ID: | 200602120322.k1C3M2Q14808@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Patch applied. Thanks.
---------------------------------------------------------------------------
Kris Jurka wrote:
>
> I've created a new shared catalog table pg_shdescription to store comments
> on cluster global objects like databases, tablespaces, and roles.
>
> It touches a lot of places, but not much in the way of big changes. The
> only design decision I made was to duplicate the query and manipulation
> functions rather than to try and have them handle both shared and local
> comments. I believe this is simpler for the code and not an issue for
> callers because they know what type of object they are dealing with. This
> has resulted in a shobj_description function analagous to obj_description
> and backend functions [Create/Delete]SharedComments mirroring the existing
> [Create/Delete]Comments functions.
>
> pg_shdescription.h goes into src/include/catalog/
>
> Kris Jurka
Content-Description:
[ Attachment, skipping... ]
Content-Description:
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey E. Koposov | 2006-02-12 03:31:13 | Re: TODO item -- Improve psql's handling of multi-line |
| Previous Message | Bruce Momjian | 2006-02-12 02:54:34 | Re: psql patch: new host/port without leaving session |